Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
SAL SAL is offline
external usenet poster
 
Posts: 1
Default how to produce a csv file from a unicode-saved text file

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving double-byte characters as unicode text in a CSV file Michael Bond Excel Discussion (Misc queries) 4 January 29th 09 10:01 PM
How to tell number of spaces between values in saved text file fromthe original xls file [email protected] Excel Discussion (Misc queries) 1 January 15th 08 11:52 AM
How to produce comma-delimited and quoted text file from Excel? Roger Kenner Excel Discussion (Misc queries) 1 September 15th 05 07:19 PM
Saved ungrouped cells to a text file EMarre Excel Discussion (Misc queries) 2 August 30th 05 02:19 PM
Exporting CSV file to unicode .txt file - " around strings Paul Excel Discussion (Misc queries) 1 June 14th 05 12:27 AM


All times are GMT +1. The time now is 11:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"