Formatting output in columns

mohsin.quazi · #1 08-23-2009

I have a file which contains data in below format:

Code:

nbkv28s MgmtReporting -> TradingDesk 1
nbkv28s RMBS -> Credits 178
nbkv28s RMBS -> PassThrough 96
nbkv28s RMBS -> Prepayment 111
nbkv28s RMBS -> RMBSHome 370
nbkv28s RMBS -> TradingStrategy 98
nbkvnze RMBS -> RMBSHome 85
nbkvugn GSF -> ABS 165

Smiling Dragon · #2 08-23-2009

Code:

#!/usr/bin/perl -w
while (<STDIN>) {
        if (/^([^\s]*)\s+([^\s]+ -> .*) (\d+)$/) { $first=$1;$second=$2;$third=$3;write }
}

format STDOUT =
@<<<<<<<<<<<< @<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< @##########
$first,$second,$third
.

cfajohnson · #3 08-23-2009

Does this do what you want? (You may have to adjust the spacing.)

Code:
awk '{ x = $2 " " $3 " " $4; printf "%-10s %-30s %4d\n", $1, x, $5}'

mohsin.quazi · #4 08-24-2009

I have become fan of awk now..

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Formatting a line of data into columns	nistleloy	UNIX for Dummies Questions & Answers	3	05-12-2009 04:52 PM
formatting the output	ragavhere	Shell Programming and Scripting	1	08-11-2008 10:03 PM
Formatting info into columns	straight_edge	Shell Programming and Scripting	8	02-05-2007 10:51 AM
Formatting output	illur81	Shell Programming and Scripting	3	10-13-2005 09:24 AM
Text formatting to 132 columns	jmossman	UNIX for Dummies Questions & Answers	16	05-06-2002 08:34 PM