Multi-Row Formula and Formula Tool

Pranab_C

I have a large dataset that I cannot share here, however I am looking to extract data between these two strings, However there could be multiple instances of the value that I need the extraction to stop at, which means that when I use this formulae it stops at the first instance, what am I doing wrong?

"IF Contains([Output], "Form 8938") THEN "START"
ELSEIF
Contains([Output], "36 If asset reported on line 29 is not stock of a foreign entity or an interest in a foreign entity, enter the following information for the asset.")
THEN "END"
ELSE "E"
ENDIF"

Gawa

Try to review the conditional statements you wrote with Contains() function. I'm not sure how your data looks like, but these statements would only match to a specific record. For example, if you want to make flag "Start" when [Output] is 'Form xxxxxxx' then you can use StartsWith([Output], "Form").

Anyway, without seeing your data, my advice cannot be more tangible any more. Sorry about it.

Contains([Output], "Form 8938")

Contains([Output], "36 If asset reported on line 29 is not stock of a foreign entity or an interest in a foreign entity, enter the following information for the asset.")