Unable to replace guillemets with spaces around them

7 views
Skip to first unread message

Ben Kazez

unread,
Nov 1, 2021, 12:54:29 PM11/1/21
to OpenRefine
Hi, I have many cells like this:

Incorporating music by Georg Anton Benda and Jacob Schuback « lost; see introduction and critical report » PHI « Movements 10–15 do not survive in any musical source; they were probably adapted. » PHI

- If I do value.replace("«", "xxx") then the values get found.
- If I do value.replace("« ", "xxx") (space after the guillemet) then nothing gets found.
- Same behavior if I use regexes.
- Same behavior in Google Sheets.

I tried inspecting these values with a unicode character inspector but that didn't reveal anything awry.

Any ideas?

Thanks!
Ben

Ben Kazez

unread,
Nov 1, 2021, 1:03:08 PM11/1/21
to openr...@googlegroups.com
I apologize, I discovered just after sending that these were hard spaces in the original data, but those weren’t coming through when copying and pasting. Not sure why that is or if OpenRefine could help, but I’ve at least managed to get things working on my end.

--
You received this message because you are subscribed to a topic in the Google Groups "OpenRefine" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/openrefine/G0qF-wm-fFk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to openrefine+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openrefine/5fe28841-78af-43c2-a3d9-44ff586be79cn%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages