topic Re: split coloumn value in QlikView https://community.qlik.com/t5/QlikView/split-coloumn-value/m-p/1263252#M867981 <HTML><HEAD></HEAD><BODY><P>load num(Textbetween(NameID,'(',')'))</P></BODY></HTML> Thu, 01 Dec 2016 13:10:31 GMT ali_hijazi 2016-12-01T13:10:31Z split coloumn value https://community.qlik.com/t5/QlikView/split-coloumn-value/m-p/1263251#M867980 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Sorry for my English</P><P>I have below table and I want to split only numbers to another coloumn with scprit.</P><P>How can I make it</P><P>Thanks</P><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid rgb(0, 0, 0); width: 110px; height: 54px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>NameID</STRONG></TH></TR><TR><TD style="padding: 2px;">Ali(1239)</TD></TR><TR><TD style="padding: 2px;">Tom(4343)</TD></TR><TR><TD style="padding: 2px;">John(95845)</TD></TR><TR><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/split-coloumn-value/m-p/1263251#M867980 mhamurcuoglu 2020-11-25T16:16:04Z Re: split coloumn value https://community.qlik.com/t5/QlikView/split-coloumn-value/m-p/1263252#M867981 <HTML><HEAD></HEAD><BODY><P>load num(Textbetween(NameID,'(',')'))</P></BODY></HTML> Thu, 01 Dec 2016 13:10:31 GMT https://community.qlik.com/t5/QlikView/split-coloumn-value/m-p/1263252#M867981 ali_hijazi 2016-12-01T13:10:31Z Re: split coloumn value https://community.qlik.com/t5/QlikView/split-coloumn-value/m-p/1263253#M867982 <HTML><HEAD></HEAD><BODY><P>or if you will always not have numbers outside of parenthesis, then you can also try this</P><P><STRONG>KeepChar(NameID, '0123456789')</STRONG></P></BODY></HTML> Thu, 01 Dec 2016 13:17:16 GMT https://community.qlik.com/t5/QlikView/split-coloumn-value/m-p/1263253#M867982 sunny_talwar 2016-12-01T13:17:16Z Re: split coloumn value https://community.qlik.com/t5/QlikView/split-coloumn-value/m-p/1263254#M867983 <HTML><HEAD></HEAD><BODY><P>Try like this </P><P>num(keepChar(NameID,'0123456789')) as new_column </P></BODY></HTML> Thu, 01 Dec 2016 13:18:06 GMT https://community.qlik.com/t5/QlikView/split-coloumn-value/m-p/1263254#M867983 avinashelite 2016-12-01T13:18:06Z Re: split coloumn value https://community.qlik.com/t5/QlikView/split-coloumn-value/m-p/1263255#M867984 <HTML><HEAD></HEAD><BODY><P>Thank you so much</P></BODY></HTML> Thu, 01 Dec 2016 13:22:17 GMT https://community.qlik.com/t5/QlikView/split-coloumn-value/m-p/1263255#M867984 mhamurcuoglu 2016-12-01T13:22:17Z