Skip to main content

All Questions

Filter by
Sorted by
Tagged with
34 votes
3 answers
20k views

How to easily edit attribute data using Regular Expressions?

I am writing a tutorial for MSc students that uses QGIS. One of the tasks requires the attribute data to be modified (see pdf draft of tutorial here if interested ). The question is how to get them ...
RobinLovelace's user avatar
10 votes
6 answers
16k views

Creating label formatted like " 1,000' " from numeric field?

This question builds on a previous question I came across at gis.stackexchange: How to easily edit attribute data using Regular Expressions? Perhaps someone can point me in the right direction? I ...
clhenrick's user avatar
  • 1,843
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.
Bruno B's user avatar
  • 849
5 votes
3 answers
392 views

Splitting string with house number in QGIS Field Calculator

I have a string field with housenumber which contains values like: housenumber 5 12 a 15 b 18 c What are the right expressions for the field calculator to write only the number in "field1&...
Enzo Baldini's user avatar
  • 2,385
5 votes
1 answer
346 views

New attribute creation using ogr and regex

I've got a folder full of dxf files with elevation values included as part of a long text attribute. I've written a regex expression to extract the elevation value, and would like to add it as a new ...
tomtomnz's user avatar
  • 637
3 votes
5 answers
1k 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 ...
Juan Millan's user avatar
3 votes
2 answers
143 views

Inserting space between address and cardinal direction in QGIS

I have a shapefile, which is a parcel map. Its table of contents has a column containing the addresses of several buildings. Some of the addresses hold directional information (i.e. n, s, w, e). The ...
Kaveh Ekbia's user avatar
3 votes
1 answer
5k views

Can you auto-populate a field in Survey123 from another field by only pulling certain characters?

I have a field where the user inputs text Aa1Bb2Cc3 Am I able to auto populate another field by only populating the field with Bb or 3. Auto populate the field with characters [4:6] or just [9] ...
M Reaume's user avatar
2 votes
4 answers
612 views

Matching backslash with regex in QGIS Field Calculator

I'm attempting to remove a part of string in an attribute column of a shapefile. The part in question is Snapshots\\ from Snapshots\390_measure_1.jpeg. So I want the output to be 390_measure_1.jpeg. ...
enor's user avatar
  • 411