topic How to Import Specific Pattern of Data. in QlikView https://community.qlik.com/t5/QlikView/How-to-Import-Specific-Pattern-of-Data/m-p/333895#M123119 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am Importing the Data from Text File. The Issue is this Particular Fields Say Item Code it has two patterns of Data.</P><P></P><P>Pattern A: 3040-403-R1123-40</P><P>Pattern B: 3040403R1123&nbsp;&nbsp; 40.</P><P></P><P>In the Script when I am Importing as Follows:</P><P></P><P>@252:271T AS [Item Code], I cant Mention Maxstring as the Pattern B makes up with spaces for the Special Characters Spaces.</P><P></P><P>My question is what condition should I use so that the Data only of the Pattern B is Imported ?</P><P></P><P>Any Help will be appreciated.</P><P></P><P>Thanks,</P><P>Madu</P></BODY></HTML> Fri, 02 Mar 2012 14:46:00 GMT 2012-03-02T14:46:00Z How to Import Specific Pattern of Data. https://community.qlik.com/t5/QlikView/How-to-Import-Specific-Pattern-of-Data/m-p/333895#M123119 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am Importing the Data from Text File. The Issue is this Particular Fields Say Item Code it has two patterns of Data.</P><P></P><P>Pattern A: 3040-403-R1123-40</P><P>Pattern B: 3040403R1123&nbsp;&nbsp; 40.</P><P></P><P>In the Script when I am Importing as Follows:</P><P></P><P>@252:271T AS [Item Code], I cant Mention Maxstring as the Pattern B makes up with spaces for the Special Characters Spaces.</P><P></P><P>My question is what condition should I use so that the Data only of the Pattern B is Imported ?</P><P></P><P>Any Help will be appreciated.</P><P></P><P>Thanks,</P><P>Madu</P></BODY></HTML> Fri, 02 Mar 2012 14:46:00 GMT https://community.qlik.com/t5/QlikView/How-to-Import-Specific-Pattern-of-Data/m-p/333895#M123119 2012-03-02T14:46:00Z