Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

parse string

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.

K

2 Replies
MVP
MVP

Re: parse string

try:

Load

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

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

From ...;

Not applicable

Re: parse string

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.