Discussion Board for collaboration on QlikView Scripting.
In my description column, I would like to pick up the ref no: but these are not the same format. I would like to know how to get the required ref: no?
Kyaw Myo Tun
Go to Solution.
I tried something like this, but this may not the feasible solution and also it will fail if there were symbols other than the used ones in script, i will look into some more solutions
Subfield(Replace(DESCRIPTION,':','-'),'-',2) as [NEW DESCRIPTION]
KeepChar(DESCRIPTION,'0123456789') as [NEW DESCRIPTION]
Dear K N,
it work well for the situation but I made a mistake in my excel. The ref no: is not only contain digit but also character. (eg....13050ABC1002). how can i get that data?
Please post sample data containing mixed text
This will help u to complete u r task.
keepchar is a string function it will help to separate text and string values
KeepChar(DESCRIPTION,'0123456789') as Newdata
Thanks and regards,
It work correctly for my purpose. Thanks for your help.