Discussion Board for collaboration on QlikView Scripting.
I have a field which looks like this:
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.
Go to Solution.
try with textbetween function
textbetween(FIELD,'(',')') as Yourfield
hope this helps
Thank you Frank