Feature request #416

delimited text file enhancement

Added by robert-medrix-org - almost 16 years ago. Updated almost 16 years ago.

Assignee:Magnus Homann
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.

Bob Catherman


#1 Updated by Magnus Homann almost 16 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.

Also available in: Atom PDF