topic Re: miminum length validation in Talend Studio

miminum length validation

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

Hi,
I want to validate postal code of having 6 digit length .How to validate minimum and maximum length of digit. I have used tSchemaComplianceCheck component but it validate only maximum length data.
Will you please suggest me how to validate minimum length of data?
Thanks in advance.

Re: miminum length validation

Anonymous — Tue, 29 Oct 2013 09:26:59 GMT

Hi abc1290,
Can you share sample input values? Both valid and invalid.
Thanks
Dwanny

Re: miminum length validation

_AnonymousUser — Tue, 29 Oct 2013 11:34:22 GMT

Hi,
valid values-411019 , 411033 ,234564 etc (output file should contain only 6 digit values).
Invalid values- 123 , 2345 , 12345678 , 23455 etc.
Thank you.

Re: miminum length validation

Anonymous — Tue, 29 Oct 2013 11:43:43 GMT

Hi
You can use tFilterRow to filter the row with customized Java code, for example:
tFileInputDelimited--main--tFitlerow--filter--tLogRow_1
--reject--tLogRow_2
check the 'advanced mode' option, and define its expression as below:
input_row.columnName.length()==6
Shong

Re: miminum length validation

_AnonymousUser — Wed, 30 Oct 2013 05:33:58 GMT

Hi,
Its working fine 🙂
Thank you.

Re: miminum length validation

_AnonymousUser — Wed, 30 Oct 2013 06:27:38 GMT

Hi,
How to trim the unnecessary spaces in the 6 digit lenght from right,left side and also from middle of the lenght.
For eg '12 345'->this gives 6 digit lenght but for me its only 5 digit ,so will you please help me out in these.
Thank you.

Re: miminum length validation

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

Hi,
There is "Trim" option in Advanced Setting of tfileinputDelimited component. Is it working for your case?
Best regards
Sabrina

Re: miminum length validation

_AnonymousUser — Wed, 30 Oct 2013 09:59:07 GMT

Hi,
The trim option which you have suggest is for trimming column.I want to trim the space inbetween digits.
for eg input is "123 456" then output will have 123456.
Thank you.

Re: miminum length validation

Anonymous — Wed, 30 Oct 2013 10:01:28 GMT

Hi abc1290,
You can refer the below link to get a similiar job:
https://community.talend.com/t5/Design-and-Development/PAN-Card-number-validation/td-p/67781
Thanks,
Dwanny