title: AWK file to split a column into two at space
body: <p>I want to take a csv file and use AWK to split a column into two parts. The column is $11 and contains words seperated by a space.</p>
  
  <p>I am trying to use </p>
  
  <pre><code>`awk -F ' ' -v OFS='|' '{ "$11=$11"; print }' | \`
  </code></pre>
  
  <p>I want to take column 11, split it into two using | as the delimiter, and then print the results.</p>
  
  <p>The results will look like -</p>
  
  <p>INPUT</p>
  
  <pre><code>1|2|3|4|5|6|7|8|9|10|11|12|13|14|15
  100|Cat|Dog|Sam|123|12345|11|G|Sam Sheparm|2121212|15*666BA  Dangers Of Cat Ownership|4/28/13|4/21/16|ACT|132132132132
  </code></pre>
  
  <p>EXPECTED OUTPUT</p>
  
  <pre><code> 1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16
   100|Cat|Dog|Sam|123|12345|11|G|Sam Sheparm|2121212|15*666BA|Dangers Of Cat Ownership|4/28/13|4/21/16|ACT|132132132132
  </code></pre>
  
  <p>What is the AWK command to split a specific column, number 11, into two prices using space. Why isn't my awk command working? Column 11 is the one that looks like 15*666BA  Dangers Of Cat Ownership. I need to split that down the middle where the space is so it is two columns.</p>