Problem when exporting a CSV file

Posted October 20th, 2009 by munthanat

Hi Jo,

I can run a map and can export a CSV file already. Thank you for your suggestions.
But I still have another problem about a exported file.It has some strange characters (e.g , ?)
Do you know why it happens? And How can I resolve this problem?

Thanks

‹ btrieve with variable-length data Error 3012 on btrv open(25529) ›

RE: Problem when exporting a CSV file

On October 20th, 2009 jterrell said:

Hi munthanat,

The most common reason for getting non-printable characters in the CSV export file is the existence of those non-printable characters in your source text file. These characters are often not visible in standard text viewers or editors due to the fact that they are non-printable, and most text viewers/editors display each as a "space" or other substitute printable character. For example, if you open your source text file (not the CSV export file) in Windows Notepad, the non-printable characters may be displayed as a small black rectangle.

To remove the non-printable characters from the CSV export file, you will need to use the Data Loader to CSV Text (http://pervasivedatatools.com/datatools/loaders/product/csv-text-uploade...). The Data Loaders include features that allow you to do extensive mapping and data transformation.

Using the Data Loader to CSV Text, you can use the RIFL scripting language and write an expression that will remove the non-printable character(s) so your final CSV data file will contain clean data.

- Jo