uDirect very long numbers get truncated

[Thomas Print]

If a field in the database contains a number longer than 16 digits the number get truncated (round off)


Field Phonenumber 18 digits
Data 111222333444555666

Result:
111222333444555660

Anyone have a clue to solve this issue!

Thomas

 

[JasonFF]

My guess is it has to do with the database itself. I would try resaving to a CSV. I might also try using Excel to set the data type for the column to Text and saving as an XLS. I've had this kind thing resolve issues with numbers not working properly before.

 

[Mark H]

Tom,

The problem is with the data type being used to store the number. The type assigned to that database field isn't long enough to store the phone number as formatted. My strong suggestion is to change the field type from a number (it's probably a long integer now) to a string field. This will also allow you to store formatting in the field if you so desire; IE (207)123-5555.

Mark H