CSV line splitter (including comments)

Open in the Regex Tester

(?x)                  # enable comments and ignore spaces
\s*,\s*               # match a comma possibly enclosed by spaces
(?=                   # start positive look ahead
  (?:[^"]*"[^"]*")*   #   match an even number of double quotes with zero or more non-quotes before, or in between
  [^"]*               #   match zero or more non-quotes
  $                   #   match the end of the line
)                     # stop positive look ahead

Splits a CSV record (a line) according RFC 4180 http://tools.ietf.org/html/rfc4180

Bart
11/19/2009 9:38:47 AM

1 comment so far.

Steve Wortham said on 1/14/2010 4:41:08 AM

Nicely done Bart!

CSV line splitter (including comments)

Open in the Regex Tester

<< back to Library

You cannot vote on your own.

You may only vote once.

You must log in to vote.