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

 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