topic Re: To create a file with rows of 400 characters in Talend Studio

To create a file with rows of 400 characters

Swiip — Sat, 16 Nov 2024 00:04:03 GMT

Hello

I have to generate a file with 6 columns of data. But they want a size of row of 400 characters. How to do this ? How to add spaces ? There is a parameter in the tFileOutputdelimited ? Or i have to use an other component ?

Thank you very much for your help.

Best regards

Re: To create a file with rows of 400 characters

gjeremy1617088143 — Fri, 11 Jun 2021 15:36:13 GMT

Hi maybe you coud look at tFileOutputPositional.

In tFileOutputPositional you could set lenght of the field, the padding char and alignement of the value

Send me Love and Kudos

Re: To create a file with rows of 400 characters

Swiip — Fri, 11 Jun 2021 16:15:28 GMT

Length of the field but i want 400 for the length of the row and not the field.

Re: To create a file with rows of 400 characters

gjeremy1617088143 — Fri, 11 Jun 2021 17:38:38 GMT

And a row can be a field :

you write your file as csv. You read it again with a none comon field delimiter like « £€£ » for example you set one field in the schema, then you write it on tfileoutputpositional with the lenght you want.

Re: To create a file with rows of 400 characters

Swiip — Wed, 16 Jun 2021 08:07:41 GMT

Thank you very much. It's ok with this solution.