Parse

[Scheruku]

Hi,

We are trying to parse the below data and the the output required is the transaction ID's...I'm not sure how to use regex and achieve the below target.

Text	Output
SUKY --HWSC7E110- 930392071	930392071
PURL - HWCD7E118 - NAGUR - 612304939	612304939
SHUBHAM BANSAL -DLCC7W8 -101230577-DELHI	101230577
KAR -HWCD7A3 -874090430-	874090430

[MarqueeCrew]

It looks like you are searching for a 9 digit number. Is that true?

[MarqueeCrew]

This video should help you learn how to find the text. 

https://youtu.be/pTZj2U2SDFA

cheers,

mark

[Scheruku]

Hi

Thank you for the videos...they were helpful. I have used the below formula to get to the desired output after watching your videos.

However, there might be other efficient ways to get the result.

Right(REGEX_replace([Narration], "[-A-Z]",""),9)

[MarqueeCrew · Accepted solution]

Regex_replace([narration],".*(\d{9}).*",'$1')

Might work too