Formatting info into columns

straight_edge · #1 (**permalink**) 02-01-2007

Hi

This question has kind of been asked before but I couldn't get any of the solutions to work.

I need to format fields being cut from a file into columns so it looks like a table.
e.g

Full name Address Hiredate
Joe Smith London 11.01.01
Bill King Liverpool 15.05.99
Harry Bloggs Leeds 12.11.04

I belive awk is used but I'm not sure how, if anyone could help that would be great

Thank you

anbu23 · #2 (**permalink**) 02-01-2007

Code:

awk ' { printf("%-20s%-15s%10s\n",$1" "$2,$3,$4) } ' file

Crazy_murli · #3 (**permalink**) 02-01-2007

One other possible ways may be ::

cat <filename> | column -t

However, the awk one mentioned above by anbu provides more formatted output.

Cheers, Murli.

straight_edge · #4 (**permalink**) 02-02-2007

Thanks for the replies

milo · #5 (**permalink**) 02-04-2007

Quote:

Originally Posted by Crazy_murli

One other possible ways may be ::

cat <filename> | column -t

However, the awk one mentioned above by anbu provides more formatted output.

Cheers, Murli.

Hi Cray_murli, it seems that column command doesn't exist.

I have table, would like to output fisrt column each line. Used awk as anbu's but output just in one line.

Hope your helps. Thanks.

anbu23 · #6 (**permalink**) 02-05-2007

Quote:

Originally Posted by milo

Hi Cray_murli, it seems that column command doesn't exist.

I have table, would like to output fisrt column each line. Used awk as anbu's but output just in one line.

Hope your helps. Thanks.

You might forgot to add newline character

Code:

awk ' { printf("%-20s%-15s%10s\n",$1" "$2,$3,$4) } ' file

c2b2 · #7 (**permalink**) 02-05-2007

Hi Every1,

Is there othr way to do the same, because awk will traverse each line and might become slow in case of very huge input file.

Correct me if I am wrong!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Formatting	mirusnet	Shell Programming and Scripting	3	01-06-2008 11:38 PM
Formatting using awk	cdunavent	Shell Programming and Scripting	2	03-18-2003 02:09 PM
Text formatting to 132 columns	jmossman	UNIX for Dummies Questions & Answers	16	05-06-2002 08:34 PM
formatting	xeron	UNIX for Dummies Questions & Answers	5	03-20-2002 11:33 AM
formatting	darryll777	UNIX for Dummies Questions & Answers	1	03-04-2002 01:15 PM

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