Splitting a Column

[kdelisi002]

I have a Column called Series and in that column there is two names, Trading [FPTS], and Trading [FPTG). I'm trying to get just the FPTS and FPTG into that column so I can join it with another set of data. Everytime I use text to columns and I can't get rid of the [ , ], ). Any ideas would be greatly appreciated.

[jdunkerley79]

try the following formula:

Regex_replace([Series], "Trading [\[\(](.*?)[\]\)]", "$1")

Output should be FPTS or FPTG 

[kdelisi002]

That worked for one but no the other. I wrote the question wrong one is Trading and the other is Trading1 sorry.

[BenMoss]

Could you just use the regex tool in parse mlde to identify a sequence of four consecutive uppercase letters.

Something like...

(\u{4})

Should work.

Ben

[jdunkerley79 · Accepted solution]

 A looser expression would be:

Regex_replace([Series], ".*?[\[\(](.*?)[\]\)].*", "$1")

This will match text between brackets and extract that

To explain the Regex:

- .*? is a non greedy capture upto a [ or ( bracket '[\[\(]

- Next it captures again non greedy until the next ] or) into $1

- Finally matches rest of like