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.

Filter by
Sorted by
Tagged with
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-...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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, ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar