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