Multi field row formula

[bsheremeta]

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 

[apathetichell · Accepted 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...

[LukeG]

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

[bsheremeta]

Thank you so much!

[apathetichell]

@bsheremetaI think you did the hardwork on this one - your formula was a-ok.