Questions tagged [string]
A sequence of characters.
207
questions
3
votes
1
answer
120
views
Split a text string with each character as an element of an array with QGIS expressions and regular expressions
I want to use QGIS expressions to split up a text string to an array with each element representing one character of the input's string, like:
input: mytext -> ouput: [ 'm', 'y', 't', 'e', 'x', 't' ...
- 31.2k
2
votes
2
answers
67
views
Avoid empty lines in QGIS labels
I´m new to QGIS yet very exited of the learning curve and automatisms it provides.
But at some point i dont manage to work around a problem.
I want to label a vector layer with differnt attributes in ...
- 60.7k
2
votes
3
answers
58
views
Replacing element of array with data from another table using QGIS Expression
How to do it in QGIS or QGIS Expression to replace the element of an array(cell value) of a table with a new value taken from another table (which contains the list of the element and its ...
- 60.7k
5
votes
2
answers
179
views
QGIS automatic fill of the attribute table by expression
I have a line layer and in the attribute list the "Name" column, which can be, for example, 'V1','V2',....'V1-2','V1-2-3',... in I'm trying to put an expression in the next column that is ...
- 3,154
10
votes
1
answer
301
views
Concatenating labels in QGIS
I am trying to display labels for polygons in a dataset. Each polygon has about 5 different fields that I want to display. Depending on the polygon, there may be NULL values in the field(s) that I am ...
- 28.8k
0
votes
1
answer
20
views
How to update string column of a shapefile GRASS GIS
I'm relatively new in GRASS GIS and I want to update a column of a shapefile.
I use GRASS GIS (version 7.8.6 on Ubuntu 20.04 .4 LTS), not the GRASS extension in QGIS.
I'm workin on a shapefile. In ...
- 15.3k
1
vote
1
answer
38
views
QGIS print layout: no options for string for path to raster image
I want to create a print layout/atlas in QGIS where an image captured by QField is displayed automatically. But now when I want to select the file path in the area Image -> Raster Image->Field ...
- 60.7k
0
votes
1
answer
35
views
Arcade Expression To Enforce Field Value String Length In a Subset of Records
Trying to apply an attribute rule to constrain a feature to a certain length (in the below example 8 character string, yet also trying to do it over a subset of data, in which attributes of another ...
- 64.7k
1
vote
2
answers
744
views
TerraClimate: Error generating chart: Data column(s) for axis #0 cannot be of type string
I am using "TerraClimate: Monthly Climate and Climatic Water Balance for Global Terrestrial Surfaces, University of Idaho" dataset...
When I try my code, I have this error message Error ...
CommunityBot
- 1
1
vote
1
answer
33
views
How to find the row number based on a set of SFC coordinates, in order to pull out the value from another column
I am new to geodetic data in R, so apologies if this is way off. I have got a dataset, with a column geometry, which contains SFC points, and a second column IntersectingPoints:
IntersectingPoints ...
- 72.5k
1
vote
1
answer
42
views
Iteratively name output files in a loop while using arcpy.conversion.FeatureClassToFeatureClass
I have four input feature classes and one feature dataset which I am trying to send them to. I would like the new feature classes to have the same names as the originals. My process is as follows:
for ...
1
vote
0
answers
40
views
Using an input string in a file path for a input vector layer in QGIS model
I am building a QGIS model to perform field calculations on a large number of .shp files containing environmental information of different waterbodies. This model should be global for the different ...
- 72.5k
1
vote
1
answer
95
views
Making new field with formatted values without leading zeros in QGIS
I have a field called "Kiinteistotunnus". The values are of the form 73499900010025. The values should be split into parts in style 734-999-0001-0025. But what should I do if I want ...
- 28.8k
4
votes
1
answer
93
views
Making new field with formatted values in QGIS
I have a column called "Kiinteistötunnus". The values are in the form 73479400010025.
Values in the whole column should be changed to form 734-794-0001-0025.
The data type is Integer64. ...
- 63
4
votes
3
answers
199
views
Adding letters, spaces, and removing parts of attribute string in QGIS
I have an attribute of the form:
12-06-065-03 W4M
and would like it in the following form:
LSD-12 SEC-06 TWP-065 RGE-03 MER-4
- 60.7k
3
votes
2
answers
69
views
Removing question marks in front of records in QGIS
I am using QGIS 3.10.3 and noticed some question marks in one column of the attribute table. These marks are just before the numbers and represent the currency symbol.
I want to get rid of them. I ...
- 60.7k
6
votes
5
answers
167
views
If any of B contains all of A, then count # of times A is in all of B
BACKGROUND: Long time reader, first time poster. Looking for help using QGIS to score data in a CSV table that was yielded from processing the contiguous neighbors of every polygon from a file with ...
- 1,770
3
votes
5
answers
478
views
Extracting digits from string in QGIS
I have a string field that I want to extract only the digits example: 1,500 m2 -> 1500
I've tried with regexp_substr("location", '(\\d*)') to remove all after the blank space, but I need ...
- 4,681
5
votes
2
answers
402
views
Splitting string into "alphabetic" or "numeric" in QGIS 3.10.1
What are the right functions and formulas with the field calculator to delete "alphabet" or "number" inside a field?
Let me be clear. I want to be able to delete "alphabetic ...
- 60.7k
5
votes
4
answers
510
views
Removing unwanted data in the cell of the QGIS Attribute table
How can I remove remove data after any special character in the cell using QGIS?
E.g.: Valli Amman Mandir, Chettiyakotai
I want only Valli Amman Mandir in the cell. The rest should be removed.
- 39.6k
1
vote
1
answer
80
views
QGIS Rule Based Labeling filter string from a value
I'm relatively new to QGIS. Recently I started mapping the hiking trails of Nepal. I used a GPX recorder application from Android Play Store. While entering the waypoint, I entered the name. The ...
- 39.6k
2
votes
3
answers
514
views
Rasterize: burning string values into raster (string to real) (QGIS)
I have to rasterize a polygon layer. Unfortunately the values of the field I have to burn into the raster has a variety of string entry's like "L239x" or "a403" (case sensitive!). RAT (Raster ...
CommunityBot
- 1
2
votes
2
answers
154
views
Getting EPSG code from QgsCoordinateReferenceSystem
I can create a QgsCoordinateReferenceSystem from a EPSG ID.
How can I get a string formatted like EPSG:4326 back from the QgsCoordinateReferenceSystem?
>>> p = QgsCoordinateReferenceSystem....
- 28.8k
0
votes
1
answer
111
views
Merge featurecollection [closed]
If I have several featurecollections in GEE, I can merge them quickly. However, if I have 1000 featurecollections, whether it means I need to type 999 'merge' in code. I think it is too time-consuming....
- 64.7k
1
vote
1
answer
105
views
Include point coordinates in a string with Google Earth Engine using JavaScript
I am making a time-series plot with data extracted from a point, and I would like to include the point coordinates in the title text.
e.g. 'Timeseries from point (61.08457, 6.03583)'
However, I can't ...
- 19.7k
23
votes
5
answers
40k
views
Using replace string function in QGIS Field Calculator
Within an attribute table, I'm trying to replace one string with another using the replace function. As an example, there are a number of features whose field "NAME" contains the string '(B)...
- 28.8k
2
votes
1
answer
61
views
How can I transform a StringList to one String
I have a column in Qgis with type:"StringList" eg
{ "name": "William", "height": "1.87", "age": 90 }, { "name": "Mary", &...
- 3,154
4
votes
1
answer
352
views
Summing numbers separated by commas in string field in QGIS
In QGIS, I have a column separated by comma (shown by column "lengths"). I want to sum up elements in it for each row. The column is a text field string.
- 19
-2
votes
1
answer
66
views
Time difference between two string fields with microsecond (or seconds) resolution using, Arcpy, datatime and UpdateCursor
I am trying to calculate (using Arcpy) the time difference between two fields that are in string data type and they have the following time format "YYY-MM-DD HH:mm:SS.sss"
I have achieved ...
- 49
1
vote
0
answers
35
views
String splits on KML conversion [closed]
I am opening this file with Google Earth and I am supposed to to do a bunch of string splits on the KML conversion since it saves the folder structure in the “PATH” field iirc. How can I do this?
Here ...
- 19.7k
1
vote
1
answer
71
views
Is it possible to overline labels / text / strings in QGIS 3.x?
I would like to overline the denominator in these fractions.
Underlining the numerator would result in too short a line when the numerator is shorter than the denominator.
The numbers in this image ...
- 10k
1
vote
0
answers
17
views
Alternate view to normal view in attribute table [closed]
I have somehow accidentally changed how my attribute table looks and I dont know how to get it to go back to the original state has anyone any idea how to change?
- 19.7k
0
votes
1
answer
2k
views
psycopg2 cursor.copy_expert() BadCopyFileFormat: extra data after last expected column when writing WKB data
I am trying to write a WKB representation (i.e. a binary string) of a Shapely Polygon into a PostgreSQL/PostGIS database using psycopg2 cursor.copy_expert() for a bulk insert.
I narrowed down the ...
- 9,363
5
votes
4
answers
236
views
Removing file type from attribute table in QGIS
I imported a shapefile that contains track plots of SGY files into QGIS, and I would like to remove '.sgy' from the file names in the attribute table.
In the image, I've highlighted the section of ...
- 28.8k
4
votes
2
answers
327
views
Geopackage in QGIS: Search and replace in all attribute fields at once
The context
I have a Geopackage file opened in QGIS. It was created by importing a CSV file. However, when importing, something regarding encoding went wrong: I have several special characters like ...
- 4,184
2
votes
0
answers
109
views
How to use WFS to update the value of a field to an empty string '', not Null？
I tried to set a field value of a feature to an empty string '' via WFS, but I didn't find a way to make it happen. I use the WFS protocol to send to Geoserver.
I tried the following three methods:
1.
...
- 43
3
votes
2
answers
278
views
Replace all but coordinates from a WKT string, including closing bracket ')'
To get a list of coordinates from a polygon and remove unwanted parts from the resulting string, the following expression works fine to remove the string elements 'Polygon', spaces and opening ...
- 13.8k
4
votes
4
answers
269
views
Extracting number with letter from the address string in QGIS [closed]
I have the following address examples to extract:
4A MANOR FARM CLOSE
38A OXFORD ROAD
56A BISHOPSTONE
and after using the following codes:
regexp_substr( "Address L2", '(\\d*) ' )
or
...
- 3,769
6
votes
1
answer
91
views
Extracting part of string from two columns at once in QGIS
I would like to extract numbers from two columns at once because I have the situation you see below.
regexp_substr(regexp_substr("Address L1", '(\\d*) ')("Address L2"), '(\\d*)')
...
- 28.8k
7
votes
2
answers
3k
views
Extracting only number from address in QGIS Attribute Table
I want to print only the number part of the address field. I tried to use the "field calculator" with "regexp_substr" to extract just the number (only string before the first space) but couldn't ...
- 28.8k
7
votes
3
answers
569
views
Extracting two last characters (numbers) doesn't work properly in QGIS
I have the string CBG/FON/BCK-STO/A1/FDJ10 and I would like to extract the 2 last numbers (sometimes one, sometimes three).
I found some hint here: Splitting string (the last digits) in QGIS
but it ...
- 28.8k
6
votes
2
answers
2k
views
Splitting string (the last digits) in QGIS
I´m working with QGIS 2.12. Is it possible to split string "from the right side" (it means I needed the last text from every field)?
In one field I have description like:
description
new ...
- 28.8k
4
votes
2
answers
553
views
Replace using regular expression in QGIS: how to mask a dot (point)?
In QGIS, I have a string with the pattern (1 character)(1 character)(dot)(number with 1 or more digits).
How can I use regexp_replace() to get the number only?
I tried regexp_replace('ab.27',('(\\D\\D(...
- 38.3k
0
votes
1
answer
224
views
How do you add user variables to custom Python functions in QGIS Function Editor?
How do you add user input variables to a Custom Function created in Python in QGIS3.x. I found the below piece of code but need to modify it to control the string to split by and the index value to ...
- 13.8k
-2
votes
1
answer
172
views
Separating characters using Python Parser of Field Calculator in ArcMap [closed]
How can I separate the characters of a string, for example, three by three with slash letters or dashes and insert them in the Attribute table in ArcMap?
abc-def-gh
a100-b200-c300
- 60k
4
votes
1
answer
219
views
Retrieve values seperated by comma's in QGIS column
What is the simplest way to retrieve each value to a new column from a string with values separated by commas in QGIS?
My data look kind of like this:
STRING
-----------
wp1,wp2,wp3
but I want
...
- 1,077
2
votes
2
answers
247
views
QGIS select by expression based on different elements concatenated inside a string
Using the field filter or advanced filter expression in the attribute table of QGIS, I want to select features that have values in the first three levels and exclude features that values other than ...
- 60.7k
7
votes
4
answers
2k
views
Labelling only with the first letter of string in QGIS
I have a field called "Genus" where there are string values, for example, the word 'Pinus'.
I want my label to show only the first letter of this word so in my example 'P'.
I was trying to ...
- 28.8k
7
votes
4
answers
541
views
Labelling with first letter taken from each word in string using QGIS
I have a field called "Species" which is composed by two words (e.g. 'Robinia pseudoacacia') and I would like to extract the first letter of both the words in order to get two letters (e.g. '...
- 28.8k
0
votes
2
answers
650
views
Extract numbers from mixed string (numbers & text) in QGIS
In QGIS 3.18. There are several similar questions such as this one which do not address my exact problem.
I have an attribute of comma-concatenated values containing text and numbers. I would like to ...
- 10k