[SOLVED] awk format output

lamont0 · 02-14-2016, 01:21 PM

New to awk. Just trying some simple examples and not quiet getting it. My data is separated with ":" and I want the output to be spaced in ordered columns. I used this command and it seems to work on the first three columns.

Code:

awk -F: 'BEGIN {format = "%-10.10s  %s\t %s\n"} {printf format, $1, $2, $3 $4 $5}' data

Quote:

101:Johnson:John:K:39000
102:King:Mary:K:39800
103:Brown:Gretchen:K:35000
104:Adams:Betty:C:42000
105:Utley:Amos:V:36000
106:Wilson:Patricia:B:39000
107:Culligan:Thomas:F:39000
108:Mitchell:Hillary:N:32800
109:Arbuckle:Margaret:F:46700
110:Ford:Terrence:H:44700
111:Greene:Sarah:L:41700
112:Rose:Richard:P:40200
113

aniels:Allan:S:30500
114:Edwards:George:J:38500

Code:

Output data:
101         Johnson      JohnK39000
102         King         MaryK39800
103         Brown        GretchenK35000
104         Adams        BettyC42000
105         Utley        AmosV36000
106         Wilson       PatriciaB39000
107         Culligan     ThomasF39000
108         Mitchell     HillaryN32800
109         Arbuckle     MargaretF46700
110         Ford         TerrenceH44700
111         Greene       SarahL41700
112         Rose         RichardP40200
113         Daniels      AllanS30500
114         Edwards      GeorgeJ38500

rknichols · 02-14-2016, 01:40 PM

An expression like "$3 $4 $5" causes those strings to be concatenated with no intervening space. If you want to pass those fields as one argument but with intervening spaces, you'll have to include the spaces in the expression:

Code:

awk -F: 'BEGIN {format = "%-10.10s  %s\t %s\n"} {printf format, $1, $2, $3 " " $4 " " $5}' data

danielbmartin · 02-14-2016, 01:42 PM

Quote:

Originally Posted by lamont0

... I want the output to be spaced in ordered columns.

There is a Linux command made for this purpose.

With this InFile ...

Code:

101:Johnson:John:K:39000
102:King:Mary:K:39800
103:Brown:Gretchen:K:35000
104:Adams:Betty:C:42000
105:Utley:Amos:V:36000
106:Wilson:Patricia:B:39000
107:Culligan:Thomas:F:39000
108:Mitchell:Hillary:N:32800
109:Arbuckle:Margaret:F:46700
110:Ford:Terrence:H:44700
111:Greene:Sarah:L:41700
112:Rose:Richard:P:40200
113:Daniels:Allan:S:30500
114:Edwards:George:J:38500

... this code ...

Code:

column -ts':' $InFile >$OutFile

... produced this OutFile ...

Code:

101  Johnson   John      K  39000
102  King      Mary      K  39800
103  Brown     Gretchen  K  35000
104  Adams     Betty     C  42000
105  Utley     Amos      V  36000
106  Wilson    Patricia  B  39000
107  Culligan  Thomas    F  39000
108  Mitchell  Hillary   N  32800
109  Arbuckle  Margaret  F  46700
110  Ford      Terrence  H  44700
111  Greene    Sarah     L  41700
112  Rose      Richard   P  40200
113  Daniels   Allan     S  30500
114  Edwards   George    J  38500

Daniel B. Martin

lamont0 · 02-14-2016, 04:11 PM

Great, thank you! I did not even notice that I left out the commas. Thank you for the column command. Another great option. This is what I found that works.

Code:

awk -F: '{printf("%-10s%-10s%-10s%-10s%-10s\n", $1, $2, $3, $4, $5)}'

Code:

Results:
101       Johnson   John      K         39000
102       King      Mary      K         39800
103       Brown     Gretchen  K         35000
104       Adams     Betty     C         42000
105       Utley     Amos      V         36000
106       Wilson    Patricia  B         39000
107       Culligan  Thomas    F         39000
108       Mitchell  Hillary   N         32800
109       Arbuckle  Margaret  F         46700
110       Ford      Terrence  H         44700
111       Greene    Sarah     L         41700
112       Rose      Richard   P         40200
113       Daniels   Allan     S         30500
114       Edwards   George    J         38500