Parsing in Qlikview - is this possible?

[josephinetedesc]

Hi All

I have a field which looks like this:

John(TeamRed)Smith

John(TeamBlue)Smith

Barry(TeamRed)Jones

Barry(TeamBlue)Jones

I need the data between the parenthesis - In Excel I would use Text to Columns - is there a way to do this in Qlikview?

Failing this how could I do this in SQL?

I would prefer not to take the column/data out to Excel and do the work there.

Jo

[Frank_Hartmann · Accepted solution]

try with textbetween function

textbetween(FIELD,'(',')') as Yourfield

hope this helps

[josephinetedesc]

Thank you Frank

worked beautifully!

Jo