topic Re: Extract Text from value within a varriable in QlikView

Extract Text from value within a varriable

alec1982 — Tue, 22 Apr 2014 16:48:25 GMT

Hi Guys,

I have a variable that looks like below:

var1=Sum(Sales) /*Sales Amount*/

The variable is generated by the script and i would like to extract the value within /**/ which is "Sales Amount"

Let me know your thoughts..

Thxs,

Badr

Re: Extract Text from value within a varriable

MK_QSL — Tue, 22 Apr 2014 16:52:21 GMT

This is Multiline comment and once your run the script, you will lose them.

Re: Extract Text from value within a varriable

pgrenier — Tue, 22 Apr 2014 17:17:13 GMT

Hello Badr,

You could use the TextBetween() function as such:

=TextBetween('$(var1)', '/*', '*/')

Regards,

Philippe

Re: Extract Text from value within a varriable

preminqlik — Tue, 22 Apr 2014 17:23:25 GMT

hi there

you have to write in script like below

set vVar1='sum(Sales)/*sum amount */'

and in frontend or backend

=TextBetween('$(vVar1)', '/*', '*/')

replace(subfield('$(vVar1)',/*',2),'*/',null())

Re: Extract Text from value within a varriable

alec1982 — Tue, 22 Apr 2014 17:59:16 GMT

TextBetween works but if the variable has Num()around it it doesn't..

var1= Num(sum(Sales),'#,##0')/*Sales Amount*/

Re: Extract Text from value within a varriable

alec1982 — Tue, 22 Apr 2014 18:05:43 GMT

Not sure about the replace statement but it seems to be wrong.. Textbetween works but the issue if the variable has Num() function around the expression then it doesn't work.

Re: Extract Text from value within a varriable

pgrenier — Tue, 22 Apr 2014 18:08:22 GMT

Hello Badr,

It is the presence of the ' character that creates the problem. You can eliminate them from the equation using the PurgeChar() function:

var1=TextBetween(PurgeChar(var1, Chr(27)), '/*', '*/')

Regards,

Philippe

Re: Extract Text from value within a varriable

alec1982 — Tue, 22 Apr 2014 18:12:49 GMT

Thxs so much!