Questions tagged [string]

A sequence of characters.

Filter by
Sorted by
Tagged with
2 votes
2 answers
93 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": &...
Syner's user avatar
  • 31
0 votes
0 answers
36 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 ...
Paul DiGirolamo's user avatar
2 votes
1 answer
78 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 ...
farmgis's user avatar
  • 45
0 votes
0 answers
26 views

NAN String on Maxent

I'm using NDVI for one of my environmental layers, i got it from google earth engine and process the data using ArcGis Desktop. I already convert it to ascii and check there's some NAN in my data. ...
MapperIndo's user avatar
3 votes
4 answers
221 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 ...
Eleanor Baker's user avatar
2 votes
3 answers
213 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 ...
Lutu's user avatar
  • 31
4 votes
2 answers
146 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 ...
Ingrid Ingravida's user avatar
2 votes
1 answer
104 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 ...
John's user avatar
  • 21
0 votes
1 answer
306 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 ...
Gonçalo Coimbra's user avatar
0 votes
1 answer
35 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 ...
HellblaZer's user avatar
3 votes
1 answer
259 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' ...
Babel's user avatar
  • 70.6k
2 votes
2 answers
116 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 ...
Toby's user avatar
  • 125
5 votes
2 answers
303 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 ...
sttipa's user avatar
  • 95
2 votes
3 answers
129 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 ...
ROEL SANTIAGO's user avatar
12 votes
1 answer
517 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 ...
JackP's user avatar
  • 323
0 votes
1 answer
27 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 ...
Giordano's user avatar
1 vote
1 answer
57 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 ...
Josh's user avatar
  • 11
0 votes
1 answer
53 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 ...
JBizz49's user avatar
  • 17
1 vote
1 answer
50 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 ...
Alex's user avatar
  • 21
4 votes
0 answers
137 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 ...
Leesbiology's user avatar
1 vote
1 answer
119 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 ...
Jussi.S.'s user avatar
4 votes
3 answers
323 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
MJM's user avatar
  • 975
1 vote
1 answer
50 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 ...
dre627's user avatar
  • 29
3 votes
2 answers
126 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 ...
GIS Noh's user avatar
  • 311
5 votes
4 answers
1k 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.
Bruno B's user avatar
  • 839
1 vote
1 answer
242 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 ...
ujjwal basnet's user avatar
2 votes
2 answers
350 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....
til_b's user avatar
  • 4,914
1 vote
1 answer
218 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 ...
Erin's user avatar
  • 157
0 votes
1 answer
247 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....
wwllpp's user avatar
  • 3
2 votes
1 answer
143 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", &...
giannisgr's user avatar
-2 votes
1 answer
95 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 ...
cerroGIS's user avatar
1 vote
0 answers
45 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 ...
Abdul Asif's user avatar
4 votes
1 answer
405 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.
Eren E's user avatar
  • 143
4 votes
1 answer
95 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. ...
Jussi.S.'s user avatar
2 votes
1 answer
101 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 ...
user99006's user avatar
  • 189
1 vote
0 answers
20 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?
sophie's user avatar
  • 11
0 votes
1 answer
3k 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 ...
swiss_knight's user avatar
  • 10.2k
4 votes
2 answers
399 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 ...
Babel's user avatar
  • 70.6k
5 votes
4 answers
300 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 ...
Amro's user avatar
  • 61
2 votes
0 answers
143 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. ...
singh's user avatar
  • 43
3 votes
2 answers
353 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 ...
Babel's user avatar
  • 70.6k
4 votes
4 answers
315 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 ...
Geographos's user avatar
  • 4,077
6 votes
1 answer
114 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*)') ...
Geographos's user avatar
  • 4,077
7 votes
3 answers
812 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 ...
Geographos's user avatar
  • 4,077
4 votes
2 answers
828 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(...
Babel's user avatar
  • 70.6k
-2 votes
1 answer
211 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
amir's user avatar
  • 1
4 votes
1 answer
371 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 ...
Erik Berg's user avatar
2 votes
2 answers
346 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 ...
CDEdwards's user avatar
  • 355
7 votes
4 answers
791 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. '...
Tommaso Se's user avatar
1 vote
2 answers
979 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 ...
pete's user avatar
  • 1,081

1
2 3 4 5