Multi-Row Formula and Formula Tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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"
Solved! Go to Solution.
- Labels:
- Data Investigation
- Transformation
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.")
![](/skins/images/5A278AAD67B5F68761E04A0A1AFFBB3D/responsive_peak/images/icon_anonymous_message.png)