Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Fixed Length to CSV conversion — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Fixed Length to CSV conversion

Accepted answer
edited Oct 29, 2019 8:58AM in Integration 11 comments


File Conversion


Hi Team,

     I am trying to convert Fixed length file to CSV The issue i am facing is:

Some of the data lines in the fixed length file don't have all the columns. So the schema considers next line of data as subsequent data and continues to process.  

For Example:


Input data:

line1:000TES000000000KNAMES, JENNIFER              123456       001 20190603     00600

line2:000TES000000000APULTZ, NAMESIS M             123456       003 20190603

Output data:

line1:000TES|000000000|KNAMES, JENNIFER              |123456       |001 |20190603|     |00600|
line2:000|TE|S0000000|00APU|L|TZ,| NAMESIS| M      | |     123|456 |      003| |20190603 |         |         |       |       |       |     |     |         |     |                                    0000500


I have attached the schema file, Input and output received.

Since it contains client data i have modified the sample accordingly.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!