Converting qlikview text field to numeric field

[edwinmatlapeng]

Hi All,

I run scripts to load QVD's from text files. Problem is my money fields appear and behave as text fields. for example, on a sum function
I get null values and when I put them on the sheet as list  boxes you can see the numbers with leadting zeroes! I have already tried the Num(Amount), Num#(Amount,'#'), num(Amount) and the Amount field would not yield.

Please help.

[edwinmatlapeng]

Strange thing is when I use Num without the hash, the values disappear!

[Sokkorn]

Hi Edwin,

Try this in your load script

Mid(Credit, FindOneOf(Credit, '123456789'))     AS [Credit],

....

Regards,

Sokkorn

[Sokkorn · Accepted solution]

Or REPLACE(LTRIM(REPLACE(Credit, '0', ' ')), ' ', '0') as Credit

[edwinmatlapeng]

Sokkorn, man! Thank you so so so much. Been awake all night! Thank you!!

[edwinmatlapeng]

this solution works as well! Thank you, man!