Multi field row formula

bsheremeta

I have a data set with the following column (txt):

16.

123

234

135

1435

64."

I need the output to be:

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

Developer

Developer Tools

Input

Accepted answers

apathetichell

2021-07-20 (1).png 2021-07-20 (2).png 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...