AnsweredAssumed Answered

Regular Expression to remove unicode symbol

Question asked by dafyddrichmond on Nov 10, 2016
Latest reply on Nov 10, 2016 by emha

Hey there,

 

I am attempting to use a regular expression to remove a right single quotation mark ( ’ ) from a text string but im not having any luck so far.This is part of a workflow that is processing data from within a csv file into a list, when the list is populated with the data the unicode symbol is changed to a ? (a white question mark within a black diamond) there are numerous different sybmbols within the data so its not as simple as just replacing the ? with a '

 

I have tried using the following as the pattern but none are doing the job

[’]

[\u2019]

\u2019

 

any ideas?

Outcomes