I've been trying put a system to check special characters for all primary keys of every tables
My idea is to use tMap, i should create a routine to check if a primary key contains at least 1 special character. If yes, it won't be integrated and be rejected, its data will be kept in tHashOutput
The point is i can't find the condition by which i could check the special characters ...
In attachment you can find the screenshot of my tMap, i should check OTI_Source. in case it contains a special character, i must put it to reject / KO
Do you have any idea about the condition i should put or another way to verify this case?
You can find a lot of examples for this kind of subject and definitively, regex is what you need to use. Using Talend you may define your own routine wich will become available for all your jobs in your project. This page may help you to define your method to search for special characters into a string https://howtodoinjava.com/regex/java-regex-allow-limit-only-alphanumeric-characters/ You can also find on the forum examples to create a routine if necessary. Hope this helps.
You can find a lot of examples for this kind of subject and definitively, regex is what you need to use. Using Talend you may define your own routine wich will become available for all your jobs in your project. This page may help you to define your method to search for special characters into a string https://howtodoinjava.com/regex/java-regex-allow-limit-only-alphanumeric-characters/ You can also find on the forum examples to create a routine if necessary. Hope this helps.
