Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try with textbetween function
textbetween(FIELD,'(',')') as Yourfield
hope this helps
try with textbetween function
textbetween(FIELD,'(',')') as Yourfield
hope this helps
Thank you Frank
worked beautifully!
Jo