load numbers only from excel

[#1]

I am loading an excel file, an one of the field is having combination of letters and numbers.....ex: John123456, 345678Peter .

I need to exclude those text characters and just load numbers as 123456,345678.....how can this be done in QV.

Thanks

[wms_manis]

Use the keepchar() function

LOAD

keepchar(A,'0123456789') as NuValField

FROM

keepchar.xlsx

[Anonymous]

Hi,

for removing text values Purgechar function will be use full for you,

EX:   SINO

        AA100

purgechar(SINO,'A') AS SINO final result is 100

Regards