Skip to main content

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

any ideas?

Hi,

You can use the Replace Susbtring in String Action (It is available in O365, I do not know in your environment)

The result is Christophes

Hope it helps,


u2019 likewise [u2019] should have worked.

I've tried it with workflow's regex run now dialog as well with the other tools and in both I did get match.

are you sure about the char's unicode value?


Reply