RegEx Pattern Desired Ouputs

[JonaV90]

Hi all,

I am trying to pull out desired columns from a string column that has many pieces of data.For this purpose, I just want to pull out 3 desired columns, station, DSP, and number.

The screenshot below shows what I'm trying to accomplish. The Pattern column is the different variations of the string column for the 3 columns I would like to pull out. There are 4 different patterns.

Can someone help me pull out these 3 different columns from the one string column using one RegEx tool?

Thank you,

[BS_THE_ANALYST · Accepted solution]

@JonaV90 here's one way using one tool:

[JonaV90]

@BS_THE_ANALYSTI found I have 2 more different patterns (5 and 6). Can you please include this in the RegEx? Also, can you help me pull out the rest of the string into a 4th column?

[BS_THE_ANALYST · Accepted solution]

@JonaV90 no problemo. 

Please find attached updated workflow.

[JonaV90]

Thank you!