Problems with importing from CSV

[make]

Hi Peggers,

iam trying to import the following from a csv file:

1022;HR STD SHORT CORRIDOR 72;BFC04; +1.50; +0.75;L;100630029

I have Problems with the values +1.50 and +0.75.
The format of the field in the table is +9.99 (both).

But after importing, i found the values 350.0 and 125.00 in the this fields.

Is that a formatting problem ?


My import code:

def var file as char no-undo.
file = "c:\vad.csv".
input from value(file).
repeat:
create vaddet.
import delimiter ";" vaddet.Pcode vaddet.bez ^ vaddet.BC vaddet.Tor ~
vaddet.Richtg vaddet´.ECode.
end.
input close.

Greets
Make

 

[Crittar]

Make,

I just tried your example (replacing your table with variables but using the data you supplied)...

I get exactly the values you would expect: 1.50 & 0.75.

Are you sure nothing else is affecting the table after you import?

 

[Dirky]

This could have something to do with the European/American numeric format. (session:numeric-format)