Skip to Content
avatar image
Former Member

Special Character ' in Information steward '

I have to handle special character O'Hare in IS rule. My code is

If i am writing my code like below mentioned method i am getting syntax error.

BEGIN RETURN

match_regex($ORT01, '[a-zA-Z .' ]*', NULL);

END

But I need my Data O'hare in the passed Records.

Please help

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 05, 2017 at 09:14 PM

    perhaps add a backspace as escape character...

    like this ...

    match_regex($ORT01, '[a-zA-Z .\' ]*', NULL);

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 09, 2017 at 03:43 PM

    Thank you so much for your help

    Add comment
    10|10000 characters needed characters exceeded