Feature request #416
delimited text file enhancement
|Pull Request or Patch supplied:||Resolution:||fixed|
|Easy fix?:||No||Copied to github as #:||10475|
I am using the "add delimited text layer" feature. I use Excel to create the Txt file (in English) and successfully add the layer in QGIS -- Works fine.
Next I need to use UNICODE to display text in Vietnamese character set. If I save the text file in "text TAB delimited" then I lose my Vietnamese characters when the file is saved by Excel. So I enter Vietnamese text successfully in Excel then save a txt file from Excel using file type "Unicode text (txt)".
In QGIS I can locate the Unicode text file successfully (file extension is "txt") but data is blank once the import is competed by QGIS. I suspect there is some difference in the format of the "Unicode text" file versus the "text TAB delimited" as created by Excel.
If this is a simple problem to solve, I think it would add a valuabe feature for many of us who work in non-English languages.
Perhaps there is a workaround -- I am happy for any solution that will allow us to move forward in our work.
#1 Updated by Magnus Homann over 14 years ago
- Resolution set to fixed
- Status changed from Open to Closed
Excel is a bit strange, when saving as Unicode(*.txt) it seems to save in tab-separated UTF-16 coded text. I got this to work with my characterset (swedish), apparently Qt recognizes UTF-16 as input. Specifying '\\t' as separator works for me.
I'm using version 0.8.0.
I'm setting this to worksforme, if it doesn't work with vietnamese characters, please attach a small sample, preferrably both in .xls and saved as Unicode.