Removing Text from beginning of imported csv text
I have a solution where we import a single, long text file into a field in FM 13. The provider has modified their output so that there are two lines of text I DON'T want to show in this field. I'm looking to remove everything before the text <SUBJECT> in this import, but also don't want all of the records I already have imported that don't include this text to be changed.
I just want to replace all of the text prior to this <SUBJECT> with a hard return.
Also, you can't import into a calculation field, but the import is a script . . . so would I import the text first, then run a "replace field contents" script with the calculated results that I want?
I was considering something like Case ( PatternCount ( field ; "<SUBJECT>" ) > 0 ; Replace ( field . . . ) ; field )
I think a string search / case routine might work, but I don't know how to set it up correctly. Any assistance would be appreciated. Thank you.
Thank you to all who may have come across this post. I tried a few things and this works :
Case ( PatternCount ( field ; "<SUBJECT>" ) > 0 ; Replace ( field ; 1 ; Position ( field ; "<SUBJECT>" ; 1 ; 1 ) -1 ; ¶ ) ; field )