Regular Expressions 101

Community Patterns

MS Excel CSV

1

Regular Expression
PCRE (PHP <7.3)

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

Description

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

Submitted by fbailly_ - 8 years ago