Change format and align the count I want to change the format From: Sample.txt Count Data 1 C0263/Pre-approved Auto Load BC 1 C0263/Pre-approved Auto Load BC Holders 3 C0268/Pre-approved Auto Loan To: Output.txt Data Count C0263/Pre-approved Auto Load BC 1 C0263/Pre-approved Auto BC Holders 1 C0268/Pre-approved Auto Loan 3

**awk** solution:


awk 'NR==1{ printf "%4s%-44s%s\
",FS,$2,$1; next }
{ f1=$1; sub(/^ *[^ ]+ */,""); printf "%4s%-44s%s\
",FS,$0,f1 }' Sample.txt


The output:


Data Count
C0263/Pre-approved Auto Load BC 1
C0263/Pre-approved Auto Load BC Holders 1
C0268/Pre-approved Auto Loan 3