Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

Parsing in Qlikview - is this possible?

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

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

try with textbetween function

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

hope this helps

View solution in original post

2 Replies
Frank_Hartmann
Master II
Master II

try with textbetween function

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

hope this helps

josephinetedesc
Creator III
Creator III
Author

Thank you Frank

worked beautifully!

Jo