topic Re: Data Validation in Talend Studio

Data Validation

Anonymous — Sat, 16 Nov 2024 11:28:55 GMT

Hi,
My job is reading FirstName from the table and I want to filter the names which have numbers/special chars in it i.e. ABC13CD, AMN$%£RE and would like to use the valid name which have only chars in it. Could you please help me in getting some help in this.
Regards,
Ram

Re: Data Validation

jd101k2000 — Fri, 03 Oct 2014 17:10:33 GMT

Hi Ram,
I'm not promising that this is the best way to do it, but it is the way I have used.
Basically I use a tMap. The field to be 'filtered' goes through this processing.
(see graphic). This removes quotes, converts all types of dash to a hyphen, changes curly quotes to straight quotes. You could add extra bits to remove other unwanted characters or use a regex.

Re: Data Validation

Anonymous — Wed, 15 Oct 2014 07:15:02 GMT

Data validation is the process of ensuring that a program operates on clean, correct and useful data. It uses routines, often called "validation rules" "validation constraints" or "check routines", that check for correctness, meaningfulness, and security of data that are input to the system . Dissertation writing service this way you can always be sure that your data is properly validated/escaped and you don't need to remember if the variable has been previously validated.

Re: Data Validation

Anonymous — Wed, 15 Oct 2014 09:57:57 GMT

Hi Ram,
Another simpler way could be to use tFilterRow and use advance settings for writing java regular expression...
Vaibhav