on 04-18-2018 4:29 AM
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
BEGIN
RETURN match_regex($parameter0, '([a-z]|[0-9])*', 'CASE_INSENSITIVE');
END
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Venken, it works perfectly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.