Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving double-byte characters as unicode text in a CSV file
I'm having a problem doing something I have done successfully before. I need
to save some double-byte characters that I see in an Excel file into a comma-delimited CSV file. Sounds simple, but I'm not getting the results I need. Here's what I'm doing with the file in Excel 2007. 1. Save As 2. Other Formats 3. CSV (MS-DOS) (*.CSV) 4. Open the file in Wordpad or Notepad Unfortunately, a cell that looks like this in Excel: 什么是情商? turns into this in the CSV file: ???????????? Any suggestions? Thanks in advance for your help! -- Michael |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving double-byte characters as unicode text in a CSV file
Hi,
I never work with this type of data, but have you looked at the JIS and the ASC functions? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Michael Bond" wrote: I'm having a problem doing something I have done successfully before. I need to save some double-byte characters that I see in an Excel file into a comma-delimited CSV file. Sounds simple, but I'm not getting the results I need. Here's what I'm doing with the file in Excel 2007. 1. Save As 2. Other Formats 3. CSV (MS-DOS) (*.CSV) 4. Open the file in Wordpad or Notepad Unfortunately, a cell that looks like this in Excel: 什么是情商? turns into this in the CSV file: ???????????? Any suggestions? Thanks in advance for your help! -- Michael |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving double-byte characters as unicode text in a CSV file
I will look into JIS and ASC. However I have done this in the past using the
process i described below (or something like it). I'm sure I'm doing something stupid but I just can't get it to work again. -- Michael "Shane Devenshire" wrote: Hi, I never work with this type of data, but have you looked at the JIS and the ASC functions? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Michael Bond" wrote: I'm having a problem doing something I have done successfully before. I need to save some double-byte characters that I see in an Excel file into a comma-delimited CSV file. Sounds simple, but I'm not getting the results I need. Here's what I'm doing with the file in Excel 2007. 1. Save As 2. Other Formats 3. CSV (MS-DOS) (*.CSV) 4. Open the file in Wordpad or Notepad Unfortunately, a cell that looks like this in Excel: 什么是情商? turns into this in the CSV file: ???????????? Any suggestions? Thanks in advance for your help! -- Michael |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving double-byte characters as unicode text in a CSV file
Choose SAVE AS
In the File Name enter "yourfilename.csv" including the quotes In the SAVE AS TYPE dropdown pick "Unicode Text (*.txt) You can also save it with any name and then change the extension from txt to csv. "Michael Bond" wrote: I will look into JIS and ASC. However I have done this in the past using the process i described below (or something like it). I'm sure I'm doing something stupid but I just can't get it to work again. -- Michael "Shane Devenshire" wrote: Hi, I never work with this type of data, but have you looked at the JIS and the ASC functions? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Michael Bond" wrote: I'm having a problem doing something I have done successfully before. I need to save some double-byte characters that I see in an Excel file into a comma-delimited CSV file. Sounds simple, but I'm not getting the results I need. Here's what I'm doing with the file in Excel 2007. 1. Save As 2. Other Formats 3. CSV (MS-DOS) (*.CSV) 4. Open the file in Wordpad or Notepad Unfortunately, a cell that looks like this in Excel: 什么是情商? turns into this in the CSV file: ???????????? Any suggestions? Thanks in advance for your help! -- Michael |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving double-byte characters as unicode text in a CSV file
That worked. Thanks! All I had to do afterwards was to search and replace
the TAB characters with commas. Thanks again! -- Michael "Sheeloo" wrote: Choose SAVE AS In the File Name enter "yourfilename.csv" including the quotes In the SAVE AS TYPE dropdown pick "Unicode Text (*.txt) You can also save it with any name and then change the extension from txt to csv. "Michael Bond" wrote: I will look into JIS and ASC. However I have done this in the past using the process i described below (or something like it). I'm sure I'm doing something stupid but I just can't get it to work again. -- Michael "Shane Devenshire" wrote: Hi, I never work with this type of data, but have you looked at the JIS and the ASC functions? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Michael Bond" wrote: I'm having a problem doing something I have done successfully before. I need to save some double-byte characters that I see in an Excel file into a comma-delimited CSV file. Sounds simple, but I'm not getting the results I need. Here's what I'm doing with the file in Excel 2007. 1. Save As 2. Other Formats 3. CSV (MS-DOS) (*.CSV) 4. Open the file in Wordpad or Notepad Unfortunately, a cell that looks like this in Excel: 什么是情商? turns into this in the CSV file: ???????????? Any suggestions? Thanks in advance for your help! -- Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extra characters exported in unicode(.txt) format | Excel Discussion (Misc queries) | |||
Saving Spreadsheet to Unicode extra quotation marks | Excel Discussion (Misc queries) | |||
Saving Spreadsheet to Unicode extra quotation marks | Excel Discussion (Misc queries) | |||
Display of Double byte chars in CSV files | Excel Discussion (Misc queries) | |||
inserting unicode characters | Excel Discussion (Misc queries) |