Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
abhaytrip
Contributor

SELECTION OF STRING

Hi all,

As im new to Qlikview , im facing this issue where in i need , if my middle character matches to 2 it goes to F1 and likewise if it matches to 4 it goes to F2.

Please refer the image for better understanding.

ive been trying it for quite sometime , thought of asking out here as well.

thanks.SNIP1.PNG

 

1 Solution

Accepted Solutions
mrybalko
Contributor II

Re: SELECTION OF STRING

LOAD
 if(mid(FIELD, 2, 1) = 2, FIELD) as F1,
 if(mid(FIELD, 2, 1) = 4, FIELD) as F2,
...
2 Replies
mrybalko
Contributor II

Re: SELECTION OF STRING

LOAD
 if(mid(FIELD, 2, 1) = 2, FIELD) as F1,
 if(mid(FIELD, 2, 1) = 4, FIELD) as F2,
...
abhaytrip
Contributor

Re: SELECTION OF STRING

Thanks alot mate , this really did work. Apprectiate it. (y)