Fail to import because a field includes delimiter

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top