title: Splitting a csv column into two columns (powershell)
body: <p>I have a csv with rows of addresses where some have apt numbers and some don't. I've been using powershell to try to split the column into two. One for the address and one for the apartment. 
  So the initial column looks like this.</p>
  
  <pre><code>839 Main St Apt 3
  130 Marcy Ave
  399 Broadway Ave Apt 6F
  </code></pre>
  
  <p>The result I'm looking for </p>
  
  <p><strong>Address column</strong></p>
  
  <pre><code>839 Main St                 
  130 Marcy Ave
  399 Broadway Ave            
  </code></pre>
  
  <p><strong>Apartment Column</strong></p>
  
  <p>Apt 3 
  blank space
  Apt 6F</p>
  
  <p>I'm trying to see how I would be able to split this. If I use a space as the delimiter, then it'll break up the adderess column into multiple columns. If I use the letter A then ill be left with pt 6F for example. What would be the right way to tackle this.</p>
  
  <p>Any help would be greatly appreciated.</p>