How do i use regex replace to identify "â_x0080__x0099_" is a string and replace it with an apostrophe.
So I want
Bishopâ_x0080__x0099_s Stortford
to become
Bishop's Stortford
Thanks in advance
Why can't you just use a regular replace?
Replace([field], "â_x0080__x0099_", "'")
@FECL3 Have you tried using the Replace option in Regex tool to do this? Here is the documentation - https://help.alteryx.com/current/en/designer/tools/parse/regex-tool.html#idp338234