Skip to main content
Nintex Community Menu Bar

Regular Expression to remove unicode symbol

  • November 10, 2016
  • 2 replies
  • 58 views
Forum|alt.badge.img

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?

    2 replies

    Forum|alt.badge.img+9

    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,

    Forum|alt.badge.img+14
    • emha
    • Scholar
    • November 10, 2016

    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?

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement