topic Removing text from string in QlikView

Removing text from string

Tue, 09 Oct 2012 09:15:05 GMT

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

MayilVahanan — Tue, 09 Oct 2012 09:16:48 GMT

Use KeepChar(FieldName,1234567890)

Hope that helps

swuehl — Tue, 09 Oct 2012 09:17:25 GMT

Try

keepchar(FIELD, '0123456789') as NEWFIELD

in your load or equivalent in an expression.