Opened 13 years ago

Closed 13 years ago

#3682 closed bug (fixed)

Delimited Text Layer Plugin and empty columns

Reported by: Zirneklītis Owned by: gsherman
Priority: major: does not work as expected Milestone: Version 1.7.0
Component: C++ Plugins Version: 1.6.0
Keywords: Delimited Text Layer Cc:
Must Fix for Release: Yes Platform: All
Platform Version: Awaiting user input: no

Description

Delimited Text Layer plug-in does not cope with TAB delimited text with extra TAB mark at the end of each row. Such a file is parsed, and a layer is added, but no geometry can be found in the map.

Attachments (2)

extra_tab_symbol.csv.zip (1.4 KB ) - added by Zirneklītis 13 years ago.
A TAB separated text file with extra TAB mark at the end of each row
extra_tab_symbol_37c.csv.zip (1.4 KB ) - added by Zirneklītis 13 years ago.
With line #37 corrected

Download all attachments as: .zip

Change History (6)

by Zirneklītis, 13 years ago

Attachment: extra_tab_symbol.csv.zip added

A TAB separated text file with extra TAB mark at the end of each row

comment:1 by volter, 13 years ago

That's not a problem of tabs at the end of lines, it doesn't seem to work with tabs at all. Substituting all tabs with pipes works for me.

What I find more problematic, is line 37 "Madona", which has one additional field.

by Zirneklītis, 13 years ago

With line #37 corrected

comment:2 by Zirneklītis, 13 years ago

Let's skip or correct this line 37. I have added the new version of the problematic file.

The problem is not in TAB as a delimiter, but with an extra TAB at the end of lines. Just remove these extra TAB symbols and the file is readable for QGIS.

In short: Delimited Text Layer plug-in is not capable to read TAB delimited text files with extra TAB symbols at the end of lines.

It's quite easy to generate such incorrectly formatted text files. Delimited Text Layer plug-in must be more forgiven for such mistakes.

comment:3 by volter, 13 years ago

Owner: changed from timlinux to gsherman

I should have said I'm trying on Trunk. Removing the trailing tabs does not help on Trunk. Just replacing them with pipes, for instance, solves the problem, even if they are trailing.

Something about trailing delimiters was corrected after 1.6, if I remember correctly, but I can't find it now.

gsherman might be the better addressee, by the way.

comment:4 by jef, 13 years ago

Resolution: fixed
Status: newclosed

the problem were the quoted column names. Fixed in r15614.

Note: See TracTickets for help on using tickets.