I want to replace all non-standard characters from fields in a dbf table in QGIS.
I see we can use something like
re.sub(r'[^\x00-\x7F]+','_', "New_Name" )
But I am not sure how to use this in the the Expression or Function Editor module.
So I have a column called "New_Name" which I want the !@#$%^&*()~`+ etc signs removed and replaced with _
Can RE be used or do we need to specify each value to replace using CASE WHEN or Replace -the solution in RE is better if it can be done in QGIS Field Calculator using the regexp_replace expression?
\\Wso the expression should read
regexp_replace( "field", '\\W+', '_' ). Consider posting it as an answer :)