Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

josephinetedesc
Not applicable

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
Not applicable

Re: Parsing in Qlikview - is this possible?

try with textbetween function

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

hope this helps

2 Replies
Frank_Hartmann
Not applicable

Re: Parsing in Qlikview - is this possible?

try with textbetween function

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

hope this helps

josephinetedesc
Not applicable

Re: Parsing in Qlikview - is this possible?

Thank you Frank

worked beautifully!

Jo