topic Re: How to load data string staring with chracter in QlikView https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115200#M368243 <HTML><HEAD></HEAD><BODY><P>Hi Prasad,</P><P>sure no problem.</P><P></P><P>Below you will find a possible solution using match:</P><P>A:</P><P>LOAD PolicyNumber</P><P>FROM</P><P>[policynumbers.xlsx](ooxml, embedded labels, table is Sheet1)</P><P>WHERE NOT match(left(PolicyNumber,1),0,1,2,3,4,5,6,7,8,9);</P><P></P><P>Kind regards,</P></BODY></HTML> Tue, 30 Aug 2016 16:52:32 GMT santiago_respane 2016-08-30T16:52:32Z How to load data string staring with chracter https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115195#M368238 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In below attached application i have a policy number column and in that i am having policy numbers starting with Numbers and Characters</P><P></P><P>But i want to load policies starting with characters only..how i can do this.</P><P></P><P>Please help..</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 30 Aug 2016 16:03:31 GMT https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115195#M368238 pra_kale 2016-08-30T16:03:31Z Re: How to load data string staring with chracter https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115196#M368239 <HTML><HEAD></HEAD><BODY><P>Hi Prasad,</P><P>you can use the <STRONG>alt</STRONG> function to determine if the first character is a number.</P><P></P><P>A:</P><P>LOAD IF(alt(left(PolicyNumber,1)),PolicyNumber) as PolicyNumber</P><P>FROM</P><P>[policynumbers.xlsx]</P><P>(ooxml, embedded labels, table is Sheet1);</P><P></P><P>Find sample attached.</P><P>Let me know if this helps.</P><P>Kind regards,</P></BODY></HTML> Tue, 30 Aug 2016 16:11:26 GMT https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115196#M368239 santiago_respane 2016-08-30T16:11:26Z Re: How to load data string staring with chracter https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115197#M368240 <HTML><HEAD></HEAD><BODY><P>Hi Santiago,</P><P></P><P>Thanks for your help..but actually want other way round. Means I want policy numbers starting with charters only should get upload.</P><P></P><P>Thanks in advance. </P></BODY></HTML> Tue, 30 Aug 2016 16:23:12 GMT https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115197#M368240 pra_kale 2016-08-30T16:23:12Z Re: How to load data string staring with chracter https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115198#M368241 <HTML><HEAD></HEAD><BODY><P>Hi Prasad,</P><P>my bad, i interpreted totally the opposite.</P><P>Here is a possible solution attached.</P><P></P><P>Please let me know if it fits your needs.</P><P>Kind regards,</P></BODY></HTML> Tue, 30 Aug 2016 16:29:32 GMT https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115198#M368241 santiago_respane 2016-08-30T16:29:32Z Re: How to load data string staring with chracter https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115199#M368242 <HTML><HEAD></HEAD><BODY><P>Thanks no problem at all...As I have a personal edition i can not open your application so can you please paste the solution the way you posted above.</P></BODY></HTML> Tue, 30 Aug 2016 16:43:08 GMT https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115199#M368242 pra_kale 2016-08-30T16:43:08Z Re: How to load data string staring with chracter https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115200#M368243 <HTML><HEAD></HEAD><BODY><P>Hi Prasad,</P><P>sure no problem.</P><P></P><P>Below you will find a possible solution using match:</P><P>A:</P><P>LOAD PolicyNumber</P><P>FROM</P><P>[policynumbers.xlsx](ooxml, embedded labels, table is Sheet1)</P><P>WHERE NOT match(left(PolicyNumber,1),0,1,2,3,4,5,6,7,8,9);</P><P></P><P>Kind regards,</P></BODY></HTML> Tue, 30 Aug 2016 16:52:32 GMT https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115200#M368243 santiago_respane 2016-08-30T16:52:32Z Re: How to load data string staring with chracter https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115201#M368244 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thank you very much Santiago...very helpful.</P></BODY></HTML> Tue, 30 Aug 2016 17:31:19 GMT https://community.qlik.com/t5/QlikView/How-to-load-data-string-staring-with-chracter/m-p/1115201#M368244 pra_kale 2016-08-30T17:31:19Z