Delete header row and reformat from tab delimited to fixed width

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

Hello gurus,

I have a file in a tab delimited format and a header row. I need a code to delete the header in the file, and convert the file to a fixed width format, with all the columns aligned. Below is a sample of the file:

HRP1000-PLVAR#HRP1000-OTYPE#HRP1000-OBJID#HRP1000-BEGDA#HRP1000-ENDDA#HRP1000-UNAME#HRP1000-SHORT#HRP1000-STEXT#
01#10#90004746560#20030124#9999441231#AU71249#0000040000#1 PROCTER & GAMBLE#
0w1#1e0#90006561#2000074444428#999914231#TT424483#100001384483#21111 LAUNDRY#
0ee1#1ee0#90006533362#200007428#99991244431#TT424483#100001443884#21121 DISH CARE#

Thanks!

2

the given file is # delimited ( not tab )

3

sorry I meant to say that it is # delimited, and not tab

4

something like this ?

 
$ nawk -F"\#" '{ if(NR>1) {for(i=1;i<=NF;i++){printf("%s\t",$i); if(i==NF){printf("\n")}}}}' test
01      10      90004746560     20030124        9999441231      AU71249 0000040000      1 PROCTER & GAMBLE              
0w1     1e0     90006561        2000074444428   999914231       TT424483        100001384483    21111 LAUNDRY           
0ee1    1ee0    90006533362     200007428       99991244431     TT424483        100001443884    21121 DISH CARE
5

yes, something like this, but columns 7, 8 & 9 are misaligned