title: MS Access Split Function with enclosed text
body: <p>I'm attempting to load text files in to a database line by line, I cannot use a standard import method as the breakdown of the file means that each line has a different number of columns, however it is thankfully comma separated.</p>
  
  <p>I'm attempting to use the 'Split' function so that I may extract certain information from each line, unfortunately any text fields are " " enclosed and some will contain comma's within the specified text.</p>
  
  <p>Is it possible to use the Split function and ignore any comma's that fall within enclosed text, if not then I'm happy to write a custom function but is it possible to determine if a text string is enclosed by " " ?</p>
  
  <p>Thanks &amp; Kind Regards,</p>
  
  <p>Matt.</p>