topic Re: Passport Number validation in Talend Studio

Passport Number validation

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

Hi,
Passport Number validation ? This should be 8 characters in size and should have 1 number as well as 1 character. 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: Passport Number validation

Anonymous — Tue, 29 Oct 2013 09:34:50 GMT

Hi abc1224,
Can you share a sample input value?
Thanks
Dwanny

Re: Passport Number validation

_AnonymousUser — Tue, 29 Oct 2013 11:27:46 GMT

Hi,
valid sample input value are-J8369854 , SJ234567 etc
Invalid sample input value are-45689 , dfghr , 123gh etc.

Thank you

Re: Passport Number validation

Anonymous — Tue, 29 Oct 2013 11:45:42 GMT

Hi
You can use tFilterRow component, all the invalid data are put in the reject flow.
Shong

Re: Passport Number validation

_AnonymousUser — Wed, 30 Oct 2013 05:47:49 GMT

Hi,
By using tfilterRow,only character size length(8)problem is solved but how to check that 8 character size strickly consist atleast 1 number as well as 1 character. i.e i want output as J8369854 not 12345678 or abcdefgh .
Thank you.

Re: Passport Number validation

Anonymous — Wed, 30 Oct 2013 09:57:06 GMT

Hi abc1224,
Please refer to the job that I have mentioned in the below post:
https://community.talend.com/t5/Design-and-Development/PAN-Card-number-validation/td-p/67781
All you will need to do is to modify the regular expression.
Thanks,
Dwanny