Import Spec Losing 3rd digit

[Mike]

I have a defined import specification the is pulling a 2 decimal place
number. It is consistently losing the third digit, for example..

28.50 comes in as 28.00
4.65 comes in as 4.60

The data type is defined as double.

Has anyone experienced this?

 

[Ken Snell [MVP]]

Show us the import specification's details. Show us an example of the data
in the text file.

 

[Larry Schuller]

If this is a fixed-length text file, the problem could be as simple as having
the starting position off by one place (remember that most positive numbers
have a leading space to provide room for the number's sign which appears only
if negative). If the numbers in your data file are right-justified and omit
trailing (insignificant) zeros (right of the decimal) that would fit your
symptoms.

Larry Schuller

 

[Larry Schuller]

(Sorry to be redundant, but I think my original reply was to the wrong person)

This has happened to me before, exactly as you described.

If this is a fixed-length text file, the problem could be as simple as having
the starting position off by one place (remember that most positive numbers
have a leading space to provide room for the number's sign which appears only
if negative). If the numbers in your data file are right-justified and omit
trailing (insignificant) zeros (right of the decimal) that would fit your
symptoms.

Larry Schuller