CSV Field Auotmatically Converted to Number When Should be Text???

[Former Member]

Hello all:

This is probably simple and I wanted to apologize if this is a stupid question BUT ... cannot seem to find this anywhere???

I am importing a CSV file into a report and all seems to work well except for one column which has data such as...

F166113186

BUT this data is converted to a number and it strips the F when I import the CSV ??? I cannot seem to find a place to change the field type in CR?

Thanks in advance!

[Former Member]

Hi,

One thing you can write simple formula for that column.

Totext(Required column)

See what happens..

--DJ

[former_member183750]

Hi Marshall

I am assuming that you are using ODBC to connec to to the CSV? That being the case, it would be the ODBC layer serving up the data to the report. Perhaps trying a different ODBC driver is an idea, or double check the data(?).

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter

[DellSC]

Is the text data in your CSV file surrounded by quotes?  That would probably force the ODBC driver to see this field as a string.  You could also try just putting quotes on this field in the first row - it may be that, like when reading Excel files, Crystal interprets the data based on the data types in the first row.

-Dell