topic Re: Excel to CSV ,chinese charecter export problem in QlikView

Excel to CSV ,chinese charecter export problem

Thu, 10 Jan 2013 12:22:42 GMT

Hi All,

I am facing this problem in which I am running a macro to convert excel file containing different coumns(english as well as one or 2 columns with chinese charecters). Now the problem is whenever I am running the Macro ,Excel file generates a CSV but the chinese charecter columns shows value like '?????' in CSV.

I want them to be in same format as in excel .And for me CSV needs to be the source to qlikview which is taking all '??????' as '??????' only.

Please help.

Re: Excel to CSV ,chinese charecter export problem

Thu, 10 Jan 2013 15:38:13 GMT

In Excel go to File > Save As > Unicode.txt and let me know if that works better.

Why do you have to be using CSV? I don't think that supports funny characters.

Re: Excel to CSV ,chinese charecter export problem

Fri, 11 Jan 2013 04:16:46 GMT

Its not working Wallerjc. And we are using CSV as a source to reduce size of data plus there are certain guidelines within project in which we can only use CSV files as a source ,thats why we are converting excel into CSV.

Guys suggest some solution to this .Any macro to take these chinese charecters from excel to CSV without converting into any garbage value like '???'

Re: Excel to CSV ,chinese charecter export problem

Fri, 11 Jan 2013 09:14:14 GMT

Do you need to keep the integrity of the Chinese characters?

Re: Excel to CSV ,chinese charecter export problem

Fri, 11 Jan 2013 09:51:52 GMT

Yes i want to keep the chinese charecters in CSV as they are in excel.