Save as Text with Unicode and Tab Delimited

If you want to eliminate """ then can't you just replace """ with nothing via Text editor ?

Am I missing something ?

thank you jindon for your reply.

if I replace the quotations with nothing then I will have more fields (columns) in my text file (this because of the information with commas in the cells of my excel file)

for example my excel file is like this
in row 1 are my headers
a1:char b1inyin c1:description
-------------------------------------------------
a2:我们 b2:wǒmen c2:we
a3:没有 b3:méiyǒu c3:not have, there is not, be without
a4:家子 b4:jiāzi c4:household, family

in this example I have 3 columns.
when saving as a text file with unicode option the registers of column C are displayed with quotations because those cells have commas.
if I eliminate the quotations my text file will show as it would have more columns because of the commas.

I tried to solve this problem not taking the commas as a delimiter but tabulation, so when i save my text file with tab delimited option i have the registers in the 3 coulmns that i need but the chinese characters becomes ????.

as far a i know, in my case saving as text with tab delimited option works better, but my big problem is that chinese characters become all in questions marks ????.

it would be great to have an option to save with unicode and tab delimited option together.

i will appreciate your help.
thanks again,

Then try

thank you jindon,

the code runs but i can't see where my new text file is saved.

i checked in my folder file and also in unit C:\ but i can't find the file created.
may i know where is it saved?

Hi

It should have saved the file down in the same folder as the workbook is in (with a .txt extension instead of .xls). If you are not finding it here, then use this small modification of Jindon's code:

Richard thank you,

yes, now i can find it.

but the new txt file still shows me the chinese characters as questions marks besides some special characters become just as normal letters. like this:

char pinyin description
-------------------------------------------------
?? women we
?? méiyou not have, there is not, be without
?? jiazi household, family


it should be like this:

char pinyin description
-------------------------------------------------
我们 wǒ men we
没有 méi yǒu not have, there is not, be without
家子 jiā zi household, family



how to solve that?

appreciate your help,

I think you need to use the FileSystemObject if you want to manipulate text files in unicode (I'm not totally certain about this). I will have a dig around in one of my old posts that deals with this. It may take me a couple of hours to come back to you.

i will wait, thank you

See if this post helps - it shows how to save as a unicode file. It will probably need to be fleshed out a bit to ensure your data is passed to the unicode file as a string variable. i can help with that if required.

http://www.mrexcel.com/forum/showthread.php?t=338526&highlight=unicode