Questions tagged [delimiter]
A delimiter is a sequence of one or more characters used to specify the boundary between separate, independent regions in plain text or other data streams.
22
questions
3
votes
1
answer
87
views
Highlight polygons using comma delimited text coordinates QGIS
I am new to GIS. I have significant CAD experience and some limited Python knowledge, and am generally familiar with basic QGIS functions.
In short, I will have several CSV files containing co-...
- 31
2
votes
2
answers
88
views
Inconsistent error opening tab-delimited text files
I have always used tab-delimited text files to bring Excel data into QGIS. By default, these are saved by Excel with the suffix".txt". Mostly there is no problem opening these and I have ...
- 941
1
vote
2
answers
33
views
QGIS regular expression while importing delimited text
I have a CSV file with following format :
UTC,Callsign,Position,Altitude
2021-05-11T11:44:38Z,FABCD,"28.084,7.452",500
...
So I can't import with personalized delimiters. I tried to use ...
- 859
6
votes
1
answer
65
views
Setting delimiter/filter in the aggregate function from QgsVectorLayer
With PyQGIS I want to aggregate some fields in my layer.
When I use:
mylayer.aggregate(QgsAggregateCalculator.StringConcatenate, myField)
Then I get a concatenated string without delimiter. So I ...
- 155
0
votes
1
answer
29
views
Converting decimals to commas in attribute table using ArcMap
I'm using ArcMap v10.8.
I am currently making a map where I need to convert the decimal numbers in my attribute table to commas to fit the standard for a different country ie: changing 100.1 to 100,1 ...
- 1
0
votes
0
answers
111
views
Adding delimited text layer
I have QGIS version 3.16 long term release.
Today I was trying to add a delimited text layer (.csv format), as I have done many times, but when I went to make the points graduated (size) based on an ...
- 1
4
votes
3
answers
482
views
Importing DAT file with different space width delimiter in QGIS 3
I'm trying to import a point located geophysics data file (.dat) in QGIS 3.18, which uses fixed width columns instead of character based delimiters. Excel has a feature to import these data, but I ...
- 43
0
votes
3
answers
214
views
PyQGIS script to add multiple delimited text layers from folder to project
I have a folder of ~120 csv files.
I would like to add them all to my QGIS project.
I know this is accomplished with the 'Data Source Manager' and 'Delimited Text' option. However, instead of adding ...
- 11
1
vote
2
answers
184
views
Comma delimited Text failed to read my imported CSV file columns
As you can see after saving my Excel file as CSV (comma delimited) and importing it to the Add delimited layer tool in QGIS, it failed to read the 4 columns and instead read it as 1 single column.
Any ...
- 59
3
votes
0
answers
60
views
Problem showing a country with non contiguous border
I am generating maps using Google Static API.
Due to browser size restrictions, I am doing a polyline encoding, using an online polyline encoder. The encoder takes long,lat with a line break.
Most ...
3
votes
1
answer
380
views
Regular expression delimiter for text file in QGIS 3
I have a text file containing coordinates but also comment lines such as :
#file description
#description point 1
id1 X1 Y1 Z1
#description point 2
id2 X2 Y2 Z2
and I want to import this file in ...
- 859
2
votes
2
answers
2k
views
Converting UTM coordinates to shapefile in QGIS
I have an excel sheet with UTM coordinates (Easting and Northing) for four points. I want to create a shapefile (rectangle) in QGIS, but am very new to the program and following all the guides I can't ...
- 23
0
votes
1
answer
369
views
Spatial Join has Merge Rule Delimiter greyed out
I'm trying to use Spatial Join between a line layer and polygon layer. Where the polygon layer contains Area Names I would like to add to the lines. Sometimes a line will cross more polygons, so I'm ...
- 467
4
votes
1
answer
1k
views
Configuring columns when adding CSV file to QGIS
I want to load a csv file into QGIS, and the data in QGIS as point layer. I have tried to use this function:
Layer ► Add layer ► Add Delimited Text Layer.
When Im loading the file name, the data ...
- 221
2
votes
2
answers
764
views
Selecting attributes which have comma delimiter
I'm currently working on a large dataset of roads. In which i have to check if the roads in 1:250 000 have the same road number as those in 1:50 000. Because of alot of generalization I have to make a ...
- 37
2
votes
2
answers
1k
views
Loading CSV File with Data Labels
I am trying to upload a CSV file with Lat and Long data in it and there are two columns that are not numeric (see picture below). Whenever I try and upload the file, QGIS recognizes it as a string ...
- 141
0
votes
2
answers
49
views
Showing lowest value first after one-to-one spatial join with delimiter?
After a spatial join (one-to-one) in ArcGIS my result looks like this: (I use a / as delimiter)
2015/2015/2014/2014/2013
After that i use python in calculate field to filter out duplicate values ...
- 1
1
vote
1
answer
94
views
Joining table to feature class using ArcGIS with Delimiter?
I have a table of attributes that correspond to different cities in my state in an excel file that I am trying to join to a polygon feature class, based on the city name.
After executing the join, ...
- 11
1
vote
0
answers
34
views
Deliminated layer cuts off imported spreadsheet at row 20
Platform: Mac, OS: Mavericks, Qgis: 2.14 Essen
Exporting spread sheet from Excel as Windows .csv. No problem publishing points to map except that import will only process 20 of 23 row entries on ...
- 11
2
votes
1
answer
2k
views
Is it possible to use non-printable characters as delimiter for text file layer in QGIS?
I am trying to import a Delimited Text File Layer from a .csv file in QGIS. Because this caused a lot of errors, I posted a question here and got the hint towards using ASCII non-printable control ...
- 201
2
votes
0
answers
72
views
Error importing NOAA’s National Geophysical Data Center as delimited text layer in QGIS version 1.02
I've been struggling with trying to import the most recent data from NOAA’s National Geophysical Data Center earthquake information into Quantum GIS 1.02 for weeks now for a class assignment.
I'm ...
1
vote
1
answer
703
views
How to change delimiter in attribute table of QGIS?
I have imported a .kml file into QGIS, and the data is all shoved together into a single field like this:
Fine, it's pipe delimited - easy to change the delimiter like in LibreOffice calc imports I ...
- 4,114