Split csv-line by Regular Expression

Question

Can you help me with parse some csv-line using regexp?
For example: 1,"2,3","2,3,""4""",,5

I need to get this array ['1' '2,3' '2,3,"4"' '' '5']

I tried to write this regexp. But its only split my line by separator ','.

(?<=,|^)([^,]*)

I find this regexp, but its work incorrect with empty cell(,,)

(\s*'[^']+'|\s*[^,]+)(?=,|$)

Can you write me right regexp to parse any string?

Answer 1

Here is the regex you are looking for:

(?<=^|,)(?:[^,"]+|")?(?=,|$)|(?<=^|,)".*?"(?=,|$)

Description

Demo

https://www.debuggex.com/r/KVwn6W1zKG4tTXSI