SELECTION OF STRING

[abhaytrip]

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.

[mrybalko · Accepted solution]

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

[abhaytrip]

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