topic Re: Text to Number Issue. in QlikView

Text to Number Issue.

Thu, 27 Nov 2014 12:30:58 GMT

Hi,

I'm loading data from a text file with the following amount format 1 000 000,00

I've tried trim, replace, num, but nothing seems to work. I cannot get rid of the spaces in order to convert to number.

Any ideas?

Pls see attached sample data and qv-file

Thanks in advance,

Olle

alexandros17 — Thu, 27 Nov 2014 12:33:49 GMT

Try with

Num(replace(myField, ' ', ''))

let me know

Anonymous — Thu, 27 Nov 2014 12:36:20 GMT

Try using

keepchar(@73:92,'1234567890,')as AMOUNT,

Instead of your REPLACE(@73:92,' ','') as AMOUNT,

Thu, 27 Nov 2014 13:30:20 GMT

Thanks Bill!

It worked! No more spaces. Perfect!

But still cannot convert to number. Any ideas why?

Pls see attched. ! !

Anonymous — Thu, 27 Nov 2014 13:37:29 GMT

Aaah!!

Need to remove the comma as well.

num(keepchar(@73:92,'1234567890')) as AMOUNT,

aveeeeeee7en — Thu, 27 Nov 2014 13:46:20 GMT

Use this:

Purgechar(AMOUNT,',')

Regards

Av7eN