Regex Parsing Help

[JP1221]

Hi,

I have a quick question regarding Regex - Parse function.

I have a set of data where there's two parts - there's a mixture of numbers and letters before a period for the first part, and the second half of the data is anything after the period.

E.g.

1234_ABC.BBBB

1234ABC.ABC<A>

ABC1234.CDE

I would like to parse the data into two columns where the first column is all the data before the period and the second column is the data after the period.

Thank you!

[Bob_Blackey · Accepted solution]

Hi JP,

Based on your data the initial text can be letters, numbers or I see an '_'

I would use the Regex Tool and Parse

(.*)\.(.*)

That would read any data until it found a '.' and then also read any data after the '.'

Cheers,

Bob

[JP1221]

It seems to work! thank you so much!

[Bob_Blackey]

No worries, as a followup - if you wanted to limit it to  a-z, A-Z, 0-9 or _

you could replace the * with \w

Bob