Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Strange thing is when I use Num without the hash, the values disappear!
Hi Edwin,
Try this in your load script
Mid(Credit, FindOneOf(Credit, '123456789')) AS [Credit],
....
Regards,
Sokkorn
Or REPLACE(LTRIM(REPLACE(Credit, '0', ' ')), ' ', '0') as Credit
Sokkorn, man! Thank you so so so much. Been awake all night! Thank you!!
this solution works as well! Thank you, man!