Regular Expressions 101

Community Library

x

MS Excel CSV

Open Workspace
  • PCRE (Legacy)
  • Match
1

Regular Expression

/
(?(?=")" ((?:""|[^"])*?)" (?:;|$) | (?: ((?<=;)$) | (.+?)(?:;|$) ) )
/
xmg

Description

Parse a generated MS Excel CSV (also works with the exported format "CSV for MS Excel" from phpmyadmin)

Submitted by fbailly_