topic Re: Extracting integer data from field in QlikView https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715981#M1066840 <HTML><HEAD></HEAD><BODY><P>try like:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KeepChar(DATA, '0123456789') as DATA</P></BODY></HTML> Fri, 05 Sep 2014 07:21:25 GMT tresB 2014-09-05T07:21:25Z Extracting integer data from field https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715980#M1066839 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i know it is very simple question but just want to know the syntex for it.</P><P><BR />I want to extract integer data only from below field.</P><TABLE border="1" class="jiveBorder" height="49" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 228px; HEIGHT: 30px; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>DATA</STRONG></TH></TR><TR><TD style="padding: 2px;">0 AU</TD></TR><TR><TD style="padding: 2px;">1 IN</TD></TR><TR><TD style="padding: 2px;">2 UK</TD></TR></TBODY></TABLE><P></P><P></P><P>output</P><TABLE border="1" class="jiveBorder" height="49" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 64px; HEIGHT: 28px; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>DATA</STRONG></TH></TR><TR><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 05 Sep 2014 07:17:36 GMT https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715980#M1066839 2014-09-05T07:17:36Z Re: Extracting integer data from field https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715981#M1066840 <HTML><HEAD></HEAD><BODY><P>try like:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KeepChar(DATA, '0123456789') as DATA</P></BODY></HTML> Fri, 05 Sep 2014 07:21:25 GMT https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715981#M1066840 tresB 2014-09-05T07:21:25Z Re: Extracting integer data from field https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715982#M1066841 <HTML><HEAD></HEAD><BODY><P>use <STRONG>left (Data,1)</STRONG> if you have 1 Digit numbers</P></BODY></HTML> Fri, 05 Sep 2014 07:21:26 GMT https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715982#M1066841 Anonymous 2014-09-05T07:21:26Z Re: Extracting integer data from field https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715983#M1066842 <HTML><HEAD></HEAD><BODY><P>no i have two,three&nbsp; digit numbers also</P></BODY></HTML> Fri, 05 Sep 2014 07:29:48 GMT https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715983#M1066842 2014-09-05T07:29:48Z Re: Extracting integer data from field https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715984#M1066843 <HTML><HEAD></HEAD><BODY><P>subfield(DATA,' ', 1)</P></BODY></HTML> Fri, 05 Sep 2014 07:37:50 GMT https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715984#M1066843 ecolomer 2014-09-05T07:37:50Z Re: Extracting integer data from field https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715985#M1066844 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">subfield(DATA,' ', 1)</SPAN></P></BODY></HTML> Fri, 05 Sep 2014 07:38:17 GMT https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715985#M1066844 ecolomer 2014-09-05T07:38:17Z Re: Extracting integer data from field https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715986#M1066845 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use can use Subfield(DATA,' ' , 1)</P><P></P><P>or </P><P>you can also use Left function (if your country code length will always be 2 )&nbsp; like this </P><P></P><P>=Left(DATA, len(DATA)-3)</P><P></P><P>Regards,</P><P>Vivek</P></BODY></HTML> Fri, 05 Sep 2014 08:32:51 GMT https://community.qlik.com/t5/QlikView/Extracting-integer-data-from-field/m-p/715986#M1066845 2014-09-05T08:32:51Z