CSV element match includes multiline

Open in the Regex Tester

(?x)                           # enable comments and ignore spaces
(
   (?:(?![\r\n])\s)*           # include white space, but not \r\n
   (?:
      [^",\s][^,\r\n]*         # if there is stuff, it cannot beging with space. If it isn't a quote, then freeform until comma or eol.
   |
      ["](?:[^"]|["]["])*["]   # if its a quote, skip double quotes and everything until another quote.
   )?
)
(,|[\r\n]*|\Z)

Alternative to split on comma, should be better performing since the split method has to count quotes until the end of the file. Check $1 for the element (includes surrounding white space), and check $2 for the delimeter for detecting the next line.

Gerard ONeill
2/19/2013 11:19:42 PM

0 comments so far.

CSV element match includes multiline

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.