title: Unix- using awk to print in table format
body: <p>I want to create a table that looks something like this, where i display the # at the front of every $2 and the Title header but I do not want to store it in my file:</p>
  
  <pre><code>Name          ID             Gender
  
  John Smith    #4567734D      Male
  Kyle Toh      #2437882L      Male
  Julianne .T   #0324153T      Female
  </code></pre>
  
  <p>I got a result like this instead:</p>
  
  <pre><code>Name          ID             Gender
  #
  Name          ID             Gender
  John Smith    #4567734D      Male
  Name          ID             Gender
  Kyle Toh      #2437882L      Male
  Name          ID             Gender
  Julianne .T   #0324153T      Female
  </code></pre>
  
  <p>By using this command:</p>
  
  <pre><code>awk -F: '   {print "Name:ID:Gender\n"} 
              {print $1":#"$2":"$3}' data.txt |column -s ":" -t
  </code></pre>