Hi,
I want to do PAN Card number validation ? This should be 10 characters in size and should have atleast 1 character and 1 number. My input file is Details.xls and output will be two file ,validePancard.xls containting valid no and other is invalid.xls file having invalid no.
Will you please suggest me which component should i use and how to do that?
Thank you in advance.
Hi abc12,
Please find attached the Talend job for your requirement. The regular expression checks the following:
* Total number of characters is exactly 10
* Contains atleast a digit
* Contains atleast one character
* Contains only alphabets or digits.
Thanks
Dwanny
Hi, I am not able to understand the code part of image(it's not visible).will you please write down the code line here i.e java.util.regx.Pattern.compile.....etc. Thank you for your valuable response.
Hi,
java.util.regex.Pattern.compile("^(?=.*\\d)(?=.*){10}$").matcher(input_row.PANNumber).find()
Here instead of PANNumber specify your column name.
Thanks,
Dwanny