Fastexport o/p file fixedwidth

Database
Enthusiast

Fastexport o/p file fixedwidth

Hi all 

i am using fastexport (a table data to file) to pull the data,  i have tried with different mode MODE RECORD FORMAT TEXT, vartext, unformatted ... i am fetch the data into flat file as a delimited but i need it as a fixed width, can anyone please suggest how to get the fixed width using fast export or any unix script to convert the delimited to fixed width

 

EmployeeNo length(3)

FirstName length(40)

LastName length(30)

BirthDate length(10)

 

sample i/p data

EmployeeNo,FirstName,LastName,BirthDate
101,Mike, James, 1/5/1980
104,Alex, Stuart, 11/6/1984
102,Robert, Williams, 3/5/1983
105,Robert, James, 12/1/1984
103,Peter, Paul, 4/1/1983

1 REPLY
Enthusiast

Re: Fastexport o/p file fixedwidth