Using QGIS Field Calculator to replace backslash?

Question

I actually use the Field Calculator "replace" formula that works very well but I have some '\' caracters in my field that I cannot replace. ex : '\naninana' and I want to keep only 'naninana'.

shouldn't "\n" be a line break? – Elio Diaz Nov 27 '17 at 19:42 — Elio Diaz, Nov 27 '17 at 19:42

score 8 · Accepted Answer · answered Nov 27 '17 at 19:51

8

If you want to remove a \ in a field, you can escape it as in:

replace(fieldname, '\\', '')

Or if you wanted to remove \n:

replace(fieldname, '\\n', '')

answered Nov 27 '17 at 19:51

larsks

1,256
1
11
24

It works with replace(fieldname, '\', '') ! Thanks a lot @larsks – Cartophyl Nov 27 '17 at 20:06

Using QGIS Field Calculator to replace backslash?

1 Answers1

Linked