1). Am I correct that the trigger is “Beneficiary’s ProForma Invoice No.”?
2. Is the 2nd row’s first 8 digits always what you are looking for?
3. Is the Alpha characters on the right side of row one always 2 characters?
If so, you should have all the text in a list format. If not, then SplitText by new line to convert the text variable to a list variable.
Now, you can do this:
Loop 0 to %List - 1% increment of 1
If %List[LoopIndex]% = “Beneficiary’s ProForma Invoice No.”
Get Subtext from %List[LoopIndex]%
Starting position: %List[LoopIndex].Count - 2%
Ending position: End of text
‘Note: if you are getting white characters at the end of “SE”, ‘trim text %List[LoopIndex]% of all white characters at the end of text’ before the IF.
Get Subtext from %List[LoopIndex] + 1%
Starting position: start
# of characters: 8
End (IF)
End (Loop)
