topic Re: Defining specific characters limit of columns in Talend Studio

Defining specific characters limit of columns

RA6 — Sat, 16 Nov 2024 09:13:34 GMT

Hello,

I have a csv file and for each column i want to define a specific limit of characters for each of them.

Example:

In my expected output :

Adresse : Limit characters to 10 only

Telephone : Limit characters to 7 only

Ville : Limit characters to 15 only

Apart making use of SubString expression, can the above result be achieved?

Is there a way to define my characters limit?

I have also tried to define them in the schema length but in vain?

Best regards,

asadasing

Re: Defining specific characters limit of columns

SachinD — Tue, 03 Oct 2017 15:48:16 GMT

Hi,

You can use tSchemaComplianceCheck, as done below

Re: Defining specific characters limit of columns

Vinlogs — Tue, 03 Oct 2017 18:59:41 GMT

Hi Asadasing,
Sachinddhake's response is perfect! I have already implemented such logic to achieve what you were looking for! So you can adopt that solution with no doubt, accept his answer and let the Talend community make use of this amazing idea! Thanks Sachin. You rock!!

Re: Defining specific characters limit of columns

RA6 — Wed, 04 Oct 2017 09:30:01 GMT

Hello Sachin and Vineet,

Thank you for your response.

My problem is that i don't want to rejet the data that exceed the max length but i want to process the data with the specific max length i have define.

Example:
Telephone length in input file = 10 or greater
Max Length defined : 7

In the output, it has to process the telephone qith only 7 characters.

Is this possible with tSchemaComplianceCheck?

Best regards,
asadasing

Re: Defining specific characters limit of columns

RA6 — Wed, 04 Oct 2017 14:33:59 GMT

Solution found.

In tSchemaComplianceCheck, i can trim the excess content of column according to the length defined.

Re: Defining specific characters limit of columns

SachinD — Wed, 04 Oct 2017 14:41:19 GMT

Thanks @asadasing, for accepting the solution and sharing tSchemaComplianceCheck Trim configuration.

Also Thanks to @Vineet for Kind words..

Lets share and Learn new things !!

Thanks,

Sachin

Re: Defining specific characters limit of columns

Vinlogs — Wed, 04 Oct 2017 14:47:03 GMT

Well said @Sachin, Sharing helps learning faster thanks