Sed to format data in a file

cnilashis · #1 (**permalink**) 08-14-2008

Hi , i need help with formatting a file i am generating which is to be used in mainframe app so the file length has to be 80 for each rows. The file that m able to generate looks like this (consists of two rows only)

Code:

 
E
1006756
1006756
Active
T
 
E
0551055
0551055
Active
T

I want the file to be like:

Code:

 
E10067561006756                Active                  T           
E05510550551055                Active                  T

(the lngth of 3rd fld - 1006756 is 30, so i have 23 space after the number, samewise the length of 4th fld is 30, so i have 24 space after the word "Active". After the word "T", i have 11 more space which is used to be a filler so that we get total 80 as the line size.

How can i ensure this using sed, i have access to shell script.
Thanks in advance for your help.

vidyadhar85 · #2 (**permalink**) 08-14-2008

try this
sed '/./N;s/\n/ /;/./N;s/\n/ /;/./N; s/\n/ /;/./N; s/\n/ /;/^$/d' filename

era · #3 (**permalink**) 08-15-2008

Are you sure sed is the right tool for the job?

Code:

awk '{ printf "%s%s%-23s%-30s%s", $1, $2, $3, $4, $5 }' filename

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
converting a tabular format data to comma seperated data in KSH	Hemamalini	UNIX for Dummies Questions & Answers	2	06-16-2008 05:37 AM
extract specific data from xml format file.	60doses	Shell Programming and Scripting	7	01-16-2008 03:26 AM
how to number format a data file without using SED?	Cactus Jack	UNIX for Dummies Questions & Answers	3	01-12-2008 07:47 PM
Check whether a given file is in ASCII format and data is tab-delimited	Mandab	Shell Programming and Scripting	9	05-03-2007 07:25 PM
write data into a text file in bold format	miltony	UNIX for Dummies Questions & Answers	1	09-28-2005 08:21 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by