Regex / Parse Assistance

[kgordish]

Hello, 

I am not a regex expert. Need some assistance to help extract a specific letter-number string from free text. 

The format always follow three letters of RQT "-" 6 digits "-" 6 digits.

Originally tried to extract only the numbers, them use tokenize to separate to different rows and then trim. This is not an option because I noticed some dates within the data set and I did not want to keep the dates. 

Sample data: 

Free Text. Free Text.

RQT-000000-000000

Free Text. Free Text.

RQT-000001-000001

RQT-101000-100100

Free Text

Desired outcome:
RQT-000000-000000

RQT-000001-000001

RQT-101000-100100

or 

RQT-000000-000000, RQT-000001-000001, RQT-101000-100100 

Then I can simply separate by using a delimiter. 

Thanks in advance and helping to level me up.

Kevin

[binuacs]

@kgordish Looking for something like below

[kgordish]

@binuacs 

Hi  Thanks for trying to assist. Sorry if  I am was unclear due to pictorial depiction.

Data Input is one row of data separated by split lines. Then a second row of Excel Data.

 

[binuacs · Accepted solution]

@kgordish Attaching the updated workflow

[kgordish]

@binuacs 

That worked. Thank you. 

The formula in regex is now understandable to me and not like reading a foreign language now.