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 · Accepted solution]

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.")