title: Convert street address from string to columns - Regex?
body: <p>I have a list of 350 addresses in a single column excel file that I need to import to a SQL table, breaking the data into columns.</p>
  
  <p>content of the Excel cells is such as this one</p>
  
  <p>Courtesy Motors 2520 Cohasset Rd - Chico, CA 95973-1307 530-893-1300   </p>
  
  <p>What strategy should I apply to import this in a clean fashion?</p>
  
  <p>I was thinking</p>
  
  <p>NAME &lt;- anything before the 1st digit</p>
  
  <p>STREET ADDRESS &lt;- from the 1st digit to the '-'</p>
  
  <p>STATE &lt;- Anything from the last ',' to the '-' immediately before  (the address field can contain some - )</p>
  
  <p>TELEPHONE &lt;- Last 12 char</p>
  
  <p>ZIP &lt;- 10 first char of the last 22 char</p>
  
  <p>I work in <code>C#</code> if this matters.</p>
  
  <p>Is RegEx the appropriate approach? I'm not too familiar with them, so I'm not sure.  Can somebody suggest a RegEx expression that would do the job (or part of it)?</p>
  
  <p>Thanks!</p>