All Questions
Tagged with regular-expression fields-attributes
9 questions
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 ...
- 4,274
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 ...
- 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.
- 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&...
- 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 ...
- 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 ...
- 41
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 ...
- 389
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]
...
- 43
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.
...
- 411