Regex Data extraction

[silver0917]

Hi Folks,

I am trying to extract any number after the SR#, SR space, SR:. How can I use Regex tool to achieve this?

The SR # has a standard format, it's always starts with 1- and 11 digits. 

Thank you for your help! 

column 1	column 2
SR# 1-42187420671	1-42187420671
	No SR #
SR  1-42275807437,Sent for Manual screening	1-42275807437
	No SR #
5267895 , refer the (ICON SR: 1-42131314351)	1-42131314351

[binuacs · Accepted solution]

@silver0917 One way of doing this with the Regex Tokenize method

[Jonathan-Sherman · Accepted solution]

Hi @silver0917,

You could use a regex expression and a formula tool to convert missing values to "No SR#".

Attached an example workflow for you to look over!

Kind regards,

Jonathan

[silver0917]

Thank you so much!