topic Re: Standed Email Formate in Talend Studio

Standed Email Formate

Anonymous — Tue, 16 Apr 2013 15:25:23 GMT

Hi All,
How to find the given email_address is valid or in valid in talend
Is there any function to follow the standed email formate ?

Thanks
Aishu

Re: Standed Email Formate

Anonymous — Tue, 16 Apr 2013 18:53:24 GMT

Write a customm routine to check if email address is valid. Use the following code in the routine

String email = ?test@test.com?;
Pattern p = Pattern.compile(?.+@.+\\.+?);
Matcher m = p.matcher(email);
boolean matchFound = m.matches();
if(matchFound){
System.out.println(?EMAIL OK?);
}else{
System.out.println(?EMAIL ERROR?);
}

Tweak the code according to your needs.
Call this function/routine in more than one jobs to check if ail is valid.
Let me know if you face any issues.

Re: Standed Email Formate

Anonymous — Tue, 16 Apr 2013 18:55:23 GMT

Forgot to mention that you will also have to import java.util.regex.* class in the routine.

Re: Standed Email Formate

Anonymous — Wed, 17 Apr 2013 09:54:53 GMT

Hi vikram thanks for your reply .
Table contains 2 laksh records and field name is email_address.
if record contain valid email_address i want to process to target table
and also in-valid email_address i want to process target table and updating with some flag=0,

how it is possible in talend?
Thanks
Aishu

Re: Standed Email Formate

Anonymous — Thu, 24 Jul 2014 09:17:11 GMT

Hi Aishu,
Based on your description, your job is now simple... it contains just simple insert.
Use code given by Vikram to set the flag status to 0 or 1 in context variable before tMap component
Use tMap to add flag column
Hope this is what you are looking for.
Thanks
Vaibhav