Skip to Content
0
Former Member
Sep 30, 2009 at 04:44 PM

Data format change when reading from a csv file

13 Views

Xi is reading/changing a data field format when reading from a csv file.

A part number field with dashes between numbers is being interpreted as a date format. See example:

10-0341-7 is being changed to 10/03/417

The same problem exists for text values that contain only numerical characters; Crystal reads them in as a number data type and leaves any values that contain alpha characters blank.

How do we prevent this?