@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)
@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
@prasath17
Thank you very much for your kind help