topic Re: Text Allignment problem. ? with TAB space. in Operating System - HP-UX

Text Allignment problem. ? with TAB space.

rveri — Thu, 08 Sep 2005 13:33:58 GMT

Hi All ,

I am Trying to print like this : username , uid , gid , gecos

With this command. But the allignment is getting disturbed.
Can any one tell , how to allign 2nd field , so that it will maintain in same column.??

$ sort -t: -k 3n,3 passwd | awk -F ":" '{ print $1 ,"\t","\t","\t",$3,"\t","\t",$4,"\t",$5}' | more

-------------------------------------------------------------------------

nobody -2 -24
root 0 3
daemon 1 5
bin 2 2
sys 3 3
adm 4 4
uucp 5 3
lp 9 7
nuucp 11 11
hpdb 27 1 ALLBASE
sna 28 21 SNAplus2 User,,,
www 30 1
sybase 100 101 ,,,
oracle 101 101 Oracle DBA,,,
dbaumgr 102 102 ,,,
dptrans 103 22 File transfer,,,
d_mirror 104 101 data mirror,x7103,,
sshd 107 103 sshd privsep
uua332 108 104 User34,username;Location2;ad2
tpcak 109 104 User35, Username2;Location3;ad3

-----------------------------------------------------------------------------

Thanks ,
Veri.

Re: Text Allignment problem. ? with TAB space.

rveri — Thu, 08 Sep 2005 13:37:03 GMT

Sorry , in the forum text box the output is not displaying properly ,

here is the attachment , that will show clear about the problem. (can be opened with wordpad. )

Thanks ,
Veri.

Re: Text Allignment problem. ? with TAB space.

Patrick Wallek — Thu, 08 Sep 2005 13:41:52 GMT

Use printf instead of just print.

If you want the names left justified:

sort -t: -k 3n,3 passwd | awk -F ":" '{ printf("%-20s,%s,%s,%s\n",$1,$3,$4,$5) }'

If you want the names right justified:
sort -t: -k 3n,3 passwd | awk -F ":" '{ printf("%20s,%s,%s,%s\n",$1,$3,$4,$5) }'

You can change the 20 in %20s to the length of your longest user name.

Re: Text Allignment problem. ? with TAB space.

James R. Ferguson — Thu, 08 Sep 2005 13:42:58 GMT

Hi Veri:

# sort -t: -k3n,3 passwd | awk -F ":" '{printf "%12s %4d %4d %s\n",$1,$3,$4,$5}'

...adjusting the widths to suit your tastes/needs.

Regards!

...JRF...

Try something like this:

Re: Text Allignment problem. ? with TAB space.

Rick Garland — Thu, 08 Sep 2005 13:44:36 GMT

The various names you get as resuly have different lengths so the tab setting is unreliable

Use the 'printf'
sort -t: -k 3n,3 passwd | awk -F ":" '{ printf
%-9s %-4s %-4s %-25s\n", $1, $3, $4, $5}' | more

You are defining the length of the fields to print. Example, $1 has 9 characters, $3 has 4 characters, etc...

Re: Text Allignment problem. ? with TAB space.

Volker Borowski — Thu, 08 Sep 2005 13:44:54 GMT

Hello,
not exactly sure, but

printf "%-20s\t%10s\t%10s\t%s\n", $1,$3,$4,$5 }

should do the job in nice formatting.
Volker

Re: Text Allignment problem. ? with TAB space.

Patrick Wallek — Thu, 08 Sep 2005 13:46:19 GMT

If you want more padding between columns (I didn't see your 2nd post until after I originally responded):

sort -t: -k 3n,3 passwd | awk -F ":" '{ printf("%20s %7s %7s %s\n",$1,$3,$4,$5) }'

Change the numbers in the %#s statements to whatever value you want.

man awk

and look at the printf section for more info.

Re: Text Allignment problem. ? with TAB space.

rveri — Thu, 08 Sep 2005 14:19:08 GMT

Hi All ,

Patrick, James works fine ,
Ricks one gives error :

$ sort -t: -k 3n,3 passwd | awk -F ":" '{ printf %-9s %-4s %-4s %-25s\n", $1, $3, $4, $5}' | more
syntax error The source line is 1.
The error context is
{ printf >>> % <<< -9s %-4s %-4s %-25s\n", $1, $3, $4, $5}
awk: The statement cannot be correctly parsed.
The source line is 1.
$
--------------------------------------------------------------

And Patrick's last one excellent , Patrick, how to make the names left allinged.

Thanks all,

Re: Text Allignment problem. ? with TAB space.

Patrick Wallek — Thu, 08 Sep 2005 14:24:36 GMT

To left align, make the %20s be %-20s and you it should work.

The command would then be:

sort -t: -k 3n,3 passwd | awk -F ":" '{ printf("%-20s %7s %7s %s\n",$1,$3,$4,$5) }'

You can do the same on any of the fields.

Re: Text Allignment problem. ? with TAB space.

rveri — Thu, 08 Sep 2005 14:31:17 GMT

Thanks Patric , James, Rick , Volker ..

And Thanks all , its working.

Re: Text Allignment problem. ? with TAB space.

rveri — Thu, 08 Sep 2005 14:32:45 GMT

Got solution. You all are .Excellent.

Re: Text Allignment problem. ? with TAB space.

Rick Garland — Thu, 08 Sep 2005 14:38:24 GMT

Sorry rveri, mine is missing the double quotes at the beginning.

Re: Text Allignment problem. ? with TAB space.

rveri — Thu, 08 Sep 2005 14:49:32 GMT

No Problem ,
Now I understood the syntax and details of %s with printf , and worked fine. Thanks for all the help and quick replies.