Fail to import because a field includes delimiter

G

Guest

Dear All,

I export a table with delimiter "|" to a text file from Informix database.
Some fileds include Chinese words. And some Chinese words include "|". It is
no problem to import it back to Informix.

When I import it with delimiter "|" into Access 2002, it fails because some
fileds include the delimiter "|". If I remove the delimiter "|" from the text
file, it casues the Chinese words are not correct. Could you provide me a
solution?

Thanks,
Simon
 
J

John Nurick

Hi Simon,

The obvious answer is to use a different delimiter, or to enclose the
data values in quotes (as in the classic CSV file, where fields that
contain commas must be enclosed in quotes), or to export it as a fixed
width file.

The other possibility is that this is a character set/code page/encoding
issue. Can you export from Informix to a Unicode text file? That should
avoid the problem, because there's no overlap in Unicode between the
"ASCII" characters (including |) and Chinese characters. (On the other
hand, if your Chinese text really contains the "ASCII" | this won't
solve the problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export to Tab delimited text file 4
Importing Data with | as the delimiter in Access 2007 6
how to change default values (delimiter etc) for Export Wizard 6
Delimited Export Specification - independent of table 3
Importing Text Files Into Access 1
Importing Fixed Length File into Access 2007 1
export database to a text file 1
Export Delimited 1

Top