I have a data set with the following column (txt):
"5
16.
123
234
135
1435
13
64."
I need the output to be:
"5
13"
So basically the rows before the number with the period (.)
I tried using multi row formula with the following:
IIF(CONTAINS([txt],"."), [Row-1:txt] , Null())
But don't seem to get the correct result
Solved! Go to Solution.
Are you using multi-row formula? If so make sure you are creating a new string column... Otherwise if you are creating a new string in multi-row formula you code seems fine.... You'd want to filter out the null()s after...
Hi @bsheremeta
Here is a workflow that uses the multirow formula to create a flag that is then used to filter out the records you are looking for.
Let me know if you have any questions!
-Luke
Thank you so much!
@bsheremetaI think you did the hardwork on this one - your formula was a-ok.