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

@JonaV90 here's one way using one tool:

ParseExample220223.yxmd