Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Total Amount field in my db which contains values such as the following:
How can I get rid of all characters which are not numeric. Basically im aiming to change to the values to:
I know I can use the replace function but is there a formula which completely gets rid of all non-numeric data?
Thanks
HI
Use KeepChar(FieldName,1234567890)
Hope that helps
HI
Use KeepChar(FieldName,1234567890)
Hope that helps
Try
keepchar(FIELD, '0123456789') as NEWFIELD
in your load or equivalent in an expression.