Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Regex replace

FECL3
8 - Asteroid

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

 

2 REPLIES 2
alexnajm
17 - Castor
17 - Castor

Why can't you just use a regular replace? 

Replace([field], "â_x0080__x0099_", "'")

TUSHAR050392
11 - Bolide

@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

 

Labels
Top Solution Authors