To create a file with rows of 400 characters

[Swiip]

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

[gjeremy1617088143]

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

[Swiip]

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

[gjeremy1617088143 · Accepted solution]

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.

[Swiip]

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