topic Re: PAN Card number validation in Talend Studio

PAN Card number validation

_AnonymousUser — Sat, 16 Nov 2024 11:51:21 GMT

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.

Re: PAN Card number validation

Anonymous — Tue, 29 Oct 2013 09:39:42 GMT

Hi abc12,
Please share a sample input value. Both valid and invalid
Thanks
Dwanny

Re: PAN Card number validation

_AnonymousUser — Tue, 29 Oct 2013 09:54:22 GMT

Hi,
valid value is CKMPS5004B or BC190D9012 etc.
Invalid value is 0012343 or ABCDSDFJHK or asd34 or AS4567 etc.

Re: PAN Card number validation

_AnonymousUser — Wed, 30 Oct 2013 05:39:01 GMT

Hi,
Waiting for your replay.
Thank you.

Re: PAN Card number validation

Anonymous — Wed, 30 Oct 2013 06:00:03 GMT

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

Re: PAN Card number validation

_AnonymousUser — Wed, 30 Oct 2013 07:44:06 GMT

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.

Re: PAN Card number validation

Anonymous — Wed, 30 Oct 2013 09:29:33 GMT

Hi,
java.util.regex.Pattern.compile("^(?=.*\\d)(?=.*){10}$").matcher(input_row.PANNumber).find()
Here instead of PANNumber specify your column name.
Thanks,
Dwanny