I am having the output like this A 1

[CALYAN]

I am having the output like this
AAO|VE|LA|21|
ABE|US|US|110|
ABJ|CI|AF|289|
ABQ|US|US|62|
ABT|SA|ME|174|
ABZ|GB|UK|437|
ACA|MX|MX|91|
ACC|GH|AF|334|
ADA|TR|EU|112|


I want the report like this

Area code Count code Reg code Count
AAO VE LA 21

how to do with awk?

 

[PHV]

Try something like this:

awk -F'|' 'BEGIN{
printf "Area code    Count code  Reg code   Count\n"
fmt="%3s             %2s          %2s    %5d\n"}
{printf fmt,$1,$2,$3,$4}
' /path/to/file

Hope This Help
PH.

 

[CALYAN]

thanks