CSV file containing Thai characters does not load into right colum

  • Thread starter Thread starter openMind
  • Start date Start date
O

openMind

I have .aspx page which has a grid with multiple columns, it supports multi
languages including Thai language. The same grid data can be exported to .csv
file.
When I download the csv file containing Thai characters and open it through
Excel, excel is not recognizing the delimiter and it is loading all columns
into one.

Can anyone tell me how to resolve this issue?
Thanks in advance.
 
the CSV option only works with comma delimited. Change the extension to
something other than CSV or Txt like XYZ Then go to excel manu and use File
- Open - and select All files. Excel should open the import GUI. Then select
the Delimited option and choose either one of the standard delimiters or
Other and put the character that is delimited into the other charaqcter box.

The other choice is to open the file with notepad and use the edit - replace
option to change the delimited character to a comma. Then save the file and
open with excel.
 
Can you export to a *.txt file and open that in Excel to get the Text
Wizard?


Gord Dibben MS Excel MVP
 
Back
Top