topic Re: parse string in QlikView

parse string

Mon, 05 Aug 2013 10:56:27 GMT

Hi,

from a field value like "80-100%" i want to extract the first % value (80) and save it in a field and also the 2nd % value (100) and save it in another field.

How can this be done ?

Thanks.

Re: parse string

tresB — Mon, 05 Aug 2013 10:59:18 GMT

try:

Load

Subfield(Yourfield, '-', 1) as Field1,

PurgeChar(Subfield(YourField, '-', 2), '%') as Field2

From ...;

Re: parse string

Mon, 05 Aug 2013 11:06:49 GMT

Hi,

I hope, you can use the function SubField(Field1,'-') for first value to be stored and TextBetween(Field1, '-','%') for second value to be stored in variable.