Extract a specific text from a field

[griseldagomes]

Hello Experts,

I am looking for a way to extract a specific text which starts with 'R1' followed by 6 characters (total character length = 8) from field 'Reference'.

unique no.	Reference
1	text 1 hello R14388AB
2	dummy R19584PE
3	6548 R1T1258X test
4	checkfile R19865WW
5	R1E9556S tester

Below is the expected output

unique no.	Reference	output
1	text 1 hello R14388AB	R14388AB
2	dummy R19584PE	R19584PE
3	6548 R1T1258X test	R1T1258X
4	checkfile R19865WW	R19865WW
5	R1E9556S tester	R1E9556S

Can you please resolve this query.

Thank you

[flying008]

@Alpha325 

Please post your error data of string.

[Alpha325]

Hi @flying008

Reference	RegExOut1
Destination code: 011234567001	01123456700
Destination code: 030-123456-001	030-123456-00

[flying008]

Hi, @Alpha325 

Parse by:

(?:R|:\s)(\S+)(?=\s|$)

******

If can help you get your want, please mark it as a solution and give a like for more share.

[Alpha325]

Thanks @flying008