I have a largely identical query to How to draw lines from two points in a CSV?, however the solution listed isnt working for me.
My original text format is PID, Start Northing, Start Easting, End Northing, End Easting.
I've tried in excel to make into a WKT compatible format, i.e.
BL2990;LINESTRING(490206.73 214102.673, 490236.94 214134.576)
This works when pasting a single line into QuickWKT, however I can't paste multiple lines in...is QuickWMT intended for a quick preview of single objects only?
In terms of importing as a delimited text file, I have arranged as:
ID;GEOM
"BL2990";"LINESTRING(490206.73 214102.673, 490236.94 214134.576)" Etc, and saved as a .txt file.
When I import as delimited text and select ";" as delimiter, the import creates the 2 column headers but fails to split the data string into ID and Geometry fields. What am I doing wrong?
I've tested importing the .txt while excluding the ID header and ID text string which works fine, however it is critical that the lines retain their identifier.