help on formatting output (Table Form) - Shell Programming and Scripting

blurboy · #1 01-17-2008

Data in File

ABC

EFGHI:123
ABCZYE

EFI:123
ABCFGD

EF:123
ABCEERRRRR

EFGHI:123

Expected Format

1 ABC DEFGHIFE 123
2 ABCZYE DEFI 123
3 ABCFGD DEF 123
4 ABCEERRRRR DEFGHI 123

However when i enter the following command:

awk 'BEGIN {FS=":"}{printf("%u %s\t%s\t%s\n", NR, $1, $2, $3)} END {print "End List"}' data.txt

Actual Output

1 ABC DEFGHIFE 123
2 ABCZYE DEFI 123
3 ABCFGD DEF 123
4 ABCEERRRRR DEFGHI 123

how can i set the width of each column?

frank_rizzo · #2 01-17-2008

get rid of the tabs and use the field width within printf. check the man page for details.

ie:

Code:

printf "%20s\n" blah

Code:

     Field Width:
             An optional digit string specifying a field width; if the output
             string has fewer characters than the field width it will be blank-
             padded on the left (or right, if the left-adjustment indicator has
             been given) to make up the field width (note that a leading zero is
             a flag, but an embedded zero is part of a field width);

also - please use the code tags around your code/data. That way we do not see smiley
faces in the middle of your data.

blurboy · #3 01-18-2008

thank you very much.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Formatting Output	dhanamurthy	Shell Programming and Scripting	6	05-02-2008 08:43 AM
Formatting bdf output	Cameron	Shell Programming and Scripting	5	04-09-2008 06:05 AM
formatting output	balaji_prk	Shell Programming and Scripting	4	09-15-2007 06:23 AM
Formatting output	illur81	Shell Programming and Scripting	3	10-13-2005 06:24 AM
Formatting the output	Cameron	Shell Programming and Scripting	7	02-15-2002 07:30 AM

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