https://community.qlik.com/t5/QlikView/Keep-numeric-from-a-character-string-with-mixed-char-and-numeric/m-p/1684413#M726771 <P>Didn't think about that one , will try (and convert the oucome to number) …. thanks seem fine.&nbsp;</P> Fri, 13 Mar 2020 10:00:41 GMT HWallays 2020-03-13T10:00:41Z https://community.qlik.com/t5/QlikView/Keep-numeric-from-a-character-string-with-mixed-char-and-numeric/m-p/1684407#M726769 <P>Is there any formula or other way to isolate the numeric value from a tekst string that holds both numeric and char data ?</P><P>For instance</P><P>&nbsp;</P><P>' AMEX_123456' shoudl deliver 123456</P><P>'MONEYMARKET:456222 TODAY' should deliver 456222</P><P>&nbsp;</P><P>In the same field the numbers can occur on various positions in the string , so I can not substract with left and right functions.</P><P>Do we have seomthing like a KEEPNUMERIC function ?</P> Sat, 16 Nov 2024 18:56:58 GMT https://community.qlik.com/t5/QlikView/Keep-numeric-from-a-character-string-with-mixed-char-and-numeric/m-p/1684407#M726769 HWallays 2024-11-16T18:56:58Z https://community.qlik.com/t5/QlikView/Keep-numeric-from-a-character-string-with-mixed-char-and-numeric/m-p/1684410#M726770 <P>You have KeepChar(). Try like:</P><P><STRONG>KeepChar</STRONG>('YourString', '0123456789')</P> Fri, 13 Mar 2020 09:57:51 GMT https://community.qlik.com/t5/QlikView/Keep-numeric-from-a-character-string-with-mixed-char-and-numeric/m-p/1684410#M726770 tresB 2020-03-13T09:57:51Z https://community.qlik.com/t5/QlikView/Keep-numeric-from-a-character-string-with-mixed-char-and-numeric/m-p/1684413#M726771 <P>Didn't think about that one , will try (and convert the oucome to number) …. thanks seem fine.&nbsp;</P> Fri, 13 Mar 2020 10:00:41 GMT https://community.qlik.com/t5/QlikView/Keep-numeric-from-a-character-string-with-mixed-char-and-numeric/m-p/1684413#M726771 HWallays 2020-03-13T10:00:41Z