Removing text from string

[#1]

Hi,

I have a Total Amount field in my db which contains values such as the following:

•      £1,500
•      n/a
•      582
•      £400

How can I get rid of all characters which are not numeric. Basically im aiming to change to the values to:

•     1500
•     
•      582
•      400

I know I can use the replace function but is there a formula which completely gets rid of all non-numeric data?

Thanks

[MayilVahanan · Accepted solution]

HI

Use KeepChar(FieldName,1234567890)

Hope that helps

[swuehl]

Try

keepchar(FIELD, '0123456789') as NEWFIELD

in your load or equivalent in an expression.