topic Re: load numbers only from excel in QlikView

load numbers only from excel

Wed, 20 Feb 2013 18:42:28 GMT

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 — Wed, 20 Feb 2013 18:48:10 GMT

Use the keepchar() function

LOAD

keepchar(A,'0123456789') as NuValField

FROM

keepchar.xlsx

Anonymous — Wed, 20 Feb 2013 19:02:28 GMT

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