cancel
Showing results for 
Search instead for 
Did you mean: 

How to check non-English characters in IS rules?

MFZhuang
Explorer
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member187605
Active Contributor

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

MFZhuang
Explorer
0 Kudos

Venken,

If I want to add some more check about symbl "."; "。", what should I do?

Ex:

ABCD.abcd Pass

ABCD。abcd Fail

. Pass

。 Fail

MFZhuang
Explorer
0 Kudos

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


Thanks Dirk again. I figured it out. I forgot to add "|" before.

Answers (2)

Answers (2)

former_member281308
Participant
0 Kudos

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.

MFZhuang
Explorer
0 Kudos

Why don't you try UTF-8? 65001

former_member281308
Participant
0 Kudos

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.

MFZhuang
Explorer
0 Kudos

Thanks Venken, it works perfectly.