title: Populate a specific column in a csv file using Powershell
body: <p>As the title says, I want to populate a specific column in a CSV file by appending to the bottom of it.</p>
  
  <p>Let's say we have a CSV table (<code>file.csv</code>) that looks like this:</p>
  
  <pre><code>     A       B        C              D
  1 "text"   "word"  "phrase"       "term"
  2 "number" "digit" "amount"       "numeral"
  3 "letter" "char"  "hieroglyphic" "symbol"
  </code></pre>
  
  <p>In my PowerShell script, I have:</p>
  
  <pre><code>$foo = "x"
  
  Out-File -FilePath file.CSV -Append -InputObject $foo
  </code></pre>
  
  <p>The result is this:</p>
  
  <pre><code>     A       B        C              D
  1 "text"   "word"  "phrase"       "term"
  2 "number" "digit" "amount"       "numeral"
  3 "letter" "char"  "hieroglyphic" "symbol"
  4   "x"
  </code></pre>
  
  <p>How do I get the value of <code>$foo</code> into a specific column such as C (below)?</p>
  
  <pre><code>     A       B        C              D
  1 "text"   "word"  "phrase"       "term"
  2 "number" "digit" "amount"       "numeral"
  3 "letter" "char"  "hieroglyphic" "symbol"
  4                    "x"
  </code></pre>