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

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

Summary

File Conversion

Content

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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