https://community.qlik.com/t5/QlikView/SELECTION-OF-STRING/m-p/1546300#M599990 <PRE>LOAD if(mid(FIELD, 2, 1) = 2, FIELD) as F1, if(mid(FIELD, 2, 1) = 4, FIELD) as F2, ...</PRE> Tue, 19 Feb 2019 11:57:59 GMT mrybalko 2019-02-19T11:57:59Z https://community.qlik.com/t5/QlikView/SELECTION-OF-STRING/m-p/1546294#M599989 <P>Hi all,</P><P>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.</P><P>Please refer the image for better understanding.</P><P>ive been trying it for quite sometime , thought of asking out here as well.</P><P>thanks.<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="SNIP1.PNG" style="width: 184px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/6317i721329500FC7D50A/image-size/small?v=v2&amp;px=200" role="button" title="SNIP1.PNG" alt="SNIP1.PNG" /></span></P><P>&nbsp;</P> Sat, 16 Nov 2024 04:24:27 GMT https://community.qlik.com/t5/QlikView/SELECTION-OF-STRING/m-p/1546294#M599989 abhaytrip 2024-11-16T04:24:27Z https://community.qlik.com/t5/QlikView/SELECTION-OF-STRING/m-p/1546300#M599990 <PRE>LOAD if(mid(FIELD, 2, 1) = 2, FIELD) as F1, if(mid(FIELD, 2, 1) = 4, FIELD) as F2, ...</PRE> Tue, 19 Feb 2019 11:57:59 GMT https://community.qlik.com/t5/QlikView/SELECTION-OF-STRING/m-p/1546300#M599990 mrybalko 2019-02-19T11:57:59Z https://community.qlik.com/t5/QlikView/SELECTION-OF-STRING/m-p/1546316#M599991 Thanks alot mate , this really did work. Apprectiate it. (y) Tue, 19 Feb 2019 12:26:33 GMT https://community.qlik.com/t5/QlikView/SELECTION-OF-STRING/m-p/1546316#M599991 abhaytrip 2019-02-19T12:26:33Z