Skip to Content

How to check non-English characters in IS rules?

I need to define a rule in IS which can filter out field contains non-English characters, such as Chinese characters, Japanese characters and son on....

I didn't find any useful Functions inside IS Advanced Editor, please let me know if you have a solution or idea.

For example:

ASASAS Pass

asasasas Pass

中文 Failed

ASAS1234 Pass

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 18 at 08:13 AM

    BEGIN
    RETURN match_regex($parameter0, '([a-z]|[0-9])*', 'CASE_INSENSITIVE');
    END

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 20 at 02:35 AM

    Thanks Venken, it works perfectly.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 22 at 12:27 PM

    Hi Dirk,

    Thanks for replay. It is good one. I have Source is Sql server( Arabic Data) and My target is Flat file. The arabic names is not loading correcly in flat file. I have checked options in flat file ( Language and Code page). I have given language (arabic) and Code page is cp1256 but still i am not getting the names correctly. how to fix the issue?.

    thanks,

    Krish.

    Add comment
    10|10000 characters needed characters exceeded

    • I have given UTF-8 the names are coming propoerly. But I have given orider Number,First Name,Last Name and Mobile number. But the text data is coming Number,Mobil Number,First Name and Last Name. How to fix the Issue?Please let us know.


      Thanks,

      krish.