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.
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.