method to increase column widths 3

[punchykool]

I am having issues getting awk to give me what I want.
All fields are pipe delimitted.
All first fields contain 7 chars.

I need:
1. column 2 to have a set width of 20 chars
2. column 4 to have a set width of 30 chars

BEFORE:

1829101|CHRYSLER|1961|WINDSOR|008|383|06277|6.3L|2BL| 20G
1815904|HONDA|1998|INTEGRA Type R|008|413|06769|6.8L|4BL| 40G


AFTER:

1829101|CHRYSLER |1961|WINDSOR |008|383|06277|6.3L|2BL| 20G
1815904|HONDA |1998|INTEGRA TYPE R |008|413|06769|6.8L|4BL| 40G


Much appreciated,

 

[vgersh99]

BEGIN {
  FS="[|]"
  OFS="|"
}
{
   $2 = sprintf("%-20s", $2);
   $4 = sprintf("%-30s", $4);
}
1

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[futurelet]

Good work, Vlad. I slightly altered your code to suit my tastes.

BEGIN { FS = OFS = "|" }

{ $2 = sprintf( "%-20s", $2 )
  $4 = sprintf( "%-30s", $4 )
  print
}

Although [tt]|[/tt] is a regular expression meta-character, it isn't necessary
to say [tt]FS="[|]"[/tt], because when FS is a single character it is treated
literally.

And [tt]print[/tt] seems a bit more clear to me than [tt]1[/tt].

For those who may be wondering, [tt]sprintf( "%-20s", $2 )[/tt] produces a
string that is the second field left-aligned in a width of 20.

 

[punchykool]

Thanks very much, you two!
-paul

 

[vgersh99]

a

to futurelet!

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[punchykool]

Ditto, Vlad.
That helps drill the logic home


-paul