how to produce a csv file from a unicode-saved text file

S

SAL

Friends,

I have an excel spreadsheet (version 2000) that has Japanese characters. I
would like to save it as unicode text file so that I can FTP it to my unix
box for loading into an Oracle database.

When I save the file as unicode text, it properly preserves the characters,
but using whitespace as the delimiters. I would like to change this to a
csv, but when I save as the file as CSV, the Japanese characters turn into
set of ?? symbols.
Is there any way around to create the unicode text file with delimiters
other than whitespace?
Thanks for any ideas.

- Sal
 

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

Top