Firstly, love the tool.
while using it i noticed that while it extracts, it also filters rows where there was not match.
This output was contrary to expectations, as the pattern may not exist in all rows.
Ideally where rows have no match it should output a null.
Thanks for the feedback! Actually the “filtering” only happens when you select the output type Rows – in this case the input row will be removed when there are zero matches, or there will be n duplicates added for one input row there are n matches.
When you select Single Row instead, the output table will always have the same number of rows as the input table. (however, you will not get multiple matches in this case).
Just to clarify: Would you still prefer to have an option a la Rows with null?