Regex to select word in the next line of a string

@Steven_McKeering HI please assist to provide the regex to select ANRA12345500 in the attached files . Also to get the same I have provided the some information in screen shot.

Sample.txt (2.3 KB)

@VB_Tech_pro - here you go…

(?<=SGD AMOUNT\s+\r?\n?\d+\s+)\S+

Assumption: SGDAmount always present in the previous line…

Hope this helps…


Hi @prasath17 thanks yes the taken string is might always present(Aprox99%). However can please try with any other word in green table.The 1% of posibility word is insted of SGD it is USD


Thank you very much for your kind help

1 Like