Removing char values from transformation of xls load

[qlikviewwizard]

Hi All,

I have Acct column in xls data file.

Values are like 111A,112N,1234,5674, so on..

How to remove char values from acct column of xls file with transformations.

Thanks in advance.

[arulsettu · Accepted solution]

HI

try like this

=KeepChar( Acct column,'0123456789')