Keep numeric from a character string with mixed char and numeric content

[HWallays]

Is there any formula or other way to isolate the numeric value from a tekst string that holds both numeric and char data ?

For instance

' AMEX_123456' shoudl deliver 123456

'MONEYMARKET:456222 TODAY' should deliver 456222

In the same field the numbers can occur on various positions in the string , so I can not substract with left and right functions.

Do we have seomthing like a KEEPNUMERIC function ?

[tresesco · Accepted solution]

You have KeepChar(). Try like:

KeepChar('YourString', '0123456789')

[HWallays]

Didn't think about that one , will try (and convert the oucome to number) …. thanks seem fine.