All Questions
Tagged with regular-expression attribute-table
9 questions
0
votes
2
answers
225
views
Identify and split data in other languages using QGIS
I have a dataset containing names in both English and other languages and mixed too. Is their any way to remove data containing other than English language?
Eg:
- 849
3
votes
3
answers
480
views
Remove symbols from text with field calculator
I'm attempting to remove € symbols from values in the attributes of a geopackage. For example, I have a value 240 123€ that I want to turn into 240 123.
I'm using the field calculator to do this. So ...
- 411
5
votes
2
answers
906
views
Replacing '.' and '-' in column values with empty space '' in QGIS
I have a shapefile that has a column named "SBL" with string values that contain points (.) and hyphens (-). However, I want to remove these points and hyphens, but so far I haven't been ...
- 389
3
votes
1
answer
3k
views
Removing part of string from the right in QGIS
I am trying to remove the last piece of my string in QGIS.
I want to delete the E10 from the end.
I tried both:
How to easily edit attribute data using Regular Expressions?
regexp_replace("UPRN&...
- 3,791
3
votes
2
answers
342
views
Replacing HTML links in attribute table Field Calculator in QGIS
I am having trouble doing a simple replace of a string in QGIS attribute table field calculator. My table has a field "tbljoined_link" that contains HTML links like <a href='islands/luzon....
- 952
1
vote
2
answers
1k
views
Replacing characters using an expression in QGIS
What regular expression can I use to change values in a string field? I need to change the letter B to a symbol - before the digits, and digits with letter F to make positive.
Like this:
- 303
7
votes
3
answers
669
views
Expression to replace characters in QGIS Attribute table
I have a string field. Which requests to put the letter F after the number to all positive digits, and the letter B after minus digits and to delete the sign -.
Finally, I want a result like this:
- 303
4
votes
2
answers
360
views
Moving substring from end to beginning of string in QGIS Attribute table
I have a large data set that contains a time range in the format 00:00-00:00 and 1-6 three-day abbreviations of days of the week (MON, TUE, WED, etc.). I managed to get all the time ranges and day ...
- 41
8
votes
2
answers
3k
views
Why do regular expressions that work on regex101.com not work in qgis?
I'm having trouble getting the qgis field calculator to validate regular expressions that work on regex101.com and also getting the same results between the two.
I'm trying to extract the digits and ...
- 1,603