I have a column called Hotlink full of incorrect directories and I need to edit them.
They currently read C:/ABCD/filename.pdf and I want them to read C:/Maps/ABCD/ABCD/filename.pdf
The script I'm trying to use but not having much luck with is as follows: replace ("Hotlink", '(ABCD)', '(Maps/ABCD/ABCD)');
How can I get this to work?
Answer
So we have a definite answer to the question:
The problem involves QGIS not liking the backslash
try this
replace ("Hotlink" , 'ABCD' , 'Maps\\ABCD\\ABCD')
see esdm.co.uk/qgis-field-calculator-backslash-gotcha
No comments:
Post a Comment