[GIS] Find and Replace ALL function in QGIS field calculator

field-calculatorfindqgisreplace

We are trying to figure out if there is a way to find and replace a "\n" string with the character "-" (hyphen).

Excel does a great job finding and replacing all, but not sure how to do same function in QGIS.

Note that the attribute table contains about 1000 of these strings so it would have to be a function that would look within the string for the \n characters without having to input the specific string by hand, if that makes sense.

Best Answer

You can try with this expression in the field calculator:

regexp_replace( "yourfield", '\\\\n', '-')

This sould replace all the \n substrings with -.

Related Solutions

ArcGIS Desktop – Removing Numeric Characters from Alphanumeric Field

I would use regular expressions. If you put the following in the code block section of the calculator it will return a string that has all digits stripped, no matter were they are:

import re
def strip_digits(s):
    return re.sub("\d+", "", s)

This can then be called from the calculate box as:

strip_digits(!column_name!)

If you want to replace characters, add another argument to the function for the replacement characters, and put it in place of the empty string.

[GIS] QGIS field-calculator replace function

It's giving you that error because it's the wrong syntax. The OR and AND keywords return true or false. The replace function is for strings so you don't really need it here. What you are looking for is the case expression:

CASE WHEN NAME="4600" OR NAME="4700" OR NAME="4800" THEN 1 END

Note: You need to be running the dev build of QGIS to get that function

Best Answer

Related Solutions

ArcGIS Desktop – Removing Numeric Characters from Alphanumeric Field

[GIS] QGIS field-calculator replace function

Related Question