title: Copy data from last column and move into new column in a file
body: <p>I want to move the data in the last column into a new column with a particular column name in the file if possible.
  The last column from which we move should be empty.</p>
  
  <p><strong>Input:Sample file</strong></p>
  
  <pre><code>Col1,col2,col3,col4
  1,abc,test,"Codes:1,2,3,4"
  2,xyz,test1,"Codes:12,22,3,4"
  3,def,test2,"Codes:1,22,3,41"
  </code></pre>
  
  <p><strong>Output:</strong></p>
  
  <pre><code>Col1,col2,col3,col4,codes
  1,abc,test,,"1,2,3,4"
  2,xyz,test1,,"12,22,3,4"
  3,def,test2,,"1,22,3,41"
  </code></pre>
  
  <p>I was able to cut the data,but unable to move it into a new column </p>
  
  <pre><code>cut -d',' -f12- &lt; file.csv | awk -F":" '{print $2}' | awk -F"\"" '{print $1}'
  </code></pre>
  
  <p>I'm not sure if this is the right approach too.</p>