Text to Number Issue.

[#1]

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]

Try with

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

let me know

[Anonymous]

Try using

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

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

[#4]

Thanks Bill!

It worked! No more spaces. Perfect!

But still cannot convert to number. Any ideas why?

Pls see attched. ! !

[Anonymous · Accepted solution]

Aaah!! 

Need to remove the comma as well.

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

[aveeeeeee7en]

Hi

Use this:

Purgechar(AMOUNT,',')

Regards

Av7eN