Questions tagged [string]
A sequence of characters.
226 questions
1
vote
1
answer
74
views
Removing wordwrap string format in QGIS
In QGIS 3.34 I used the wordwrap function to split a long text into two lines. But how can I undo it? So that I have the text on one line again?
- 73
1
vote
1
answer
106
views
Multipart objects from part of a text
The text is joined by nearest to the objects.
But is there a way to multipart objects just from text? E.G.'T1-I11', 'T1-I5'
As there are multiple objects with the first half of the text, is it ...
- 157
3
votes
1
answer
120
views
Using string output of custom function with rule-based symbology in QGIS
I want to use the following custom function in a ruled-based symbology of a layer to filter features by the names of visible layers within another layer group:
@qgsfunction(args='auto', group='Custom')...
- 193
1
vote
1
answer
49
views
Create an asset ID by combining string and number
I'm trying to export an earth engine image to asset with an asset id that is a combination of string and number.
var assetId = 'projects/dashboard/assets/recent_mtch'; //
var ID = ee.Number(1231)....
- 145
0
votes
0
answers
46
views
QGIS - list/string comparison using SQLite
I'm using SQLite to process multiple queries while working with SpatiaLite layers.
I need to identify which string has been added to a list after updating the layer. Currently, my approach involves ...
- 1,027
0
votes
1
answer
92
views
QGIS - SpatiaLite - SQLite string manipulations (position/replace)
I have two layers :
Layer 1: ESPECES_HABITATS_ATTRIBUTS, with fields 'espece' (containing
unique values) and 'distance' (an integer).
Layer 2: ESPECES_HABITATS_POLY, with fields 'ESPECE' (a ...
- 1,027
1
vote
2
answers
86
views
String function to shorten a string value
In QGIS, I'm trying to create a new variable with a short description of a string value of another variable. For example, in the table below, I would like to have:
NAMEABB = "US 1" when NAME ...
- 13
0
votes
1
answer
138
views
Field Calculator populating a new field with strings based on old field with integers
I have two fields, one is old, Ftype, one is new, Ftype_name. I would like to have python read the numbers in Ftype and populate Ftype_name with the string. I used to know how to do this before they ...
2
votes
2
answers
304
views
GeoJSON item considered a JSON instead of a string
Some items in a geojson file work correctly in a linux environment but not in a windows environment. The following structure: { "name": "1", "key": { "start": &...
- 31
0
votes
0
answers
40
views
Preserve string field type and leading zeros when using arcpy.conversion.TableToTable to go from CSV to GDB table? [duplicate]
I'm building an ArcMap script tool that will be run on many different input table schemas for geocoding purposes. When importing from CSV to GDB table using the arcpy.conversion.TableToTable function ...
2
votes
1
answer
185
views
Picking Input Layer according to attribute string in QGIS Graphic Modeler
My model is based on a vector layer which contains a Field with layer names. The Plan is to pick the input raster (from a directory or directly from the project layers) according to an attribute value ...
- 45
3
votes
4
answers
361
views
Extracting 'hour' from 'time_stamp' with QGIS
I am trying to extract the hour from my time_stamp which is in the format dd/mm/yyyy 00:00:00 as a textstring.
I am using the expression hour("time_stamp") in the field calculator, but the ...
2
votes
3
answers
289
views
Formatting string with QGIS Expression builder: separate groups of fours digits with hyphens
I'm trying to make a label ruled based. I have a numerical value:
123412341234
and try to write an expression to make it look like this:
1234-1234-1234
I tried using substr but I get an error when ...
- 95
4
votes
2
answers
199
views
Creating a concatenated field with conditions, changing a numeric field to 4 digits
Starting from a table with fields:
"ID" (14 digit string)
"COND" (numeric)
"CDC1" (1 digit string)
"CDC2" (1 digit string)
The goal is to concatenate with an ...
- 2,676
2
votes
1
answer
450
views
Extracting or selecting only 4 digit numbers from attribute field
I have a field, this field has integer numbers, what I need is to find only the 4 digit numbers and select/extract them. I do know a few solutions but they didn’t work out. What exactly I want to do ...
- 21
0
votes
1
answer
3k
views
Could not add feature with geometry type MultiLineString to layer of type MultiPolygon [duplicate]
I´m trying to make the Union of two shapefiles on QGIS 3.28.9 and keep getting this error message:
Feature could not be written to Union_8f811877_53f7_4317_ae22_fe05e7ab9695: Could not add feature ...
0
votes
1
answer
48
views
Creating an ascending network of strings using two columns
I'm attempting to build a network based on the 'From' and 'To' columns. Essentially, each number in the 'From' column is connected to a corresponding number in the 'To' column. Subsequently, I need to ...
- 41
3
votes
1
answer
493
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' ...
- 80.4k
2
votes
2
answers
206
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 ...
- 155
5
votes
2
answers
478
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 ...
- 197
2
votes
3
answers
198
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 ...
12
votes
1
answer
1k
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 ...
- 333
0
votes
1
answer
52
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 ...
- 5
1
vote
1
answer
72
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 ...
- 11
0
votes
1
answer
141
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 ...
- 17
1
vote
1
answer
114
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 ...
- 21
4
votes
0
answers
215
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 ...
- 41
1
vote
1
answer
165
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 ...
- 63
4
votes
3
answers
556
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
- 1,035
1
vote
1
answer
76
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 ...
- 29
3
votes
2
answers
308
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 ...
- 402
5
votes
4
answers
2k
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.
- 879
1
vote
1
answer
431
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 ...
- 121
2
votes
2
answers
643
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....
- 5,335
1
vote
1
answer
300
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 ...
- 149
0
votes
1
answer
798
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....
- 3
2
votes
1
answer
379
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", &...
- 23
-2
votes
1
answer
122
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
63
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 ...
- 11
4
votes
1
answer
499
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.
- 143
4
votes
1
answer
119
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
2
votes
1
answer
155
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 ...
- 199
1
vote
0
answers
29
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?
- 11
0
votes
1
answer
4k
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 ...
- 11.4k
5
votes
2
answers
535
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 ...
- 80.4k
5
votes
4
answers
378
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 ...
- 61
4
votes
0
answers
251
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.
...
- 73
3
votes
2
answers
478
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 ...
- 80.4k
4
votes
4
answers
376
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,061
6
votes
1
answer
140
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*)')
...
- 3,061