Split on comma, but not on quote-enclosed comma

[zdrakec]

i.e. I want to split a string on , unless the , is quoted, thus:

"She is a , very 'fine,girl', and she walks, everyday"

should end up as:

"She is a"
"very 'fine,girl'"
"and she walks"
"everyday"

Help???

Cheers,
zdrakec

 

[zdrakec]

Got it:

system.Text.RegularExpressions.Regex.Split("She is a , very
'fine,girl', and she walks, everyday",",\s'*,*'*")

Thanks,
zdrakec

 

[zdrakec]

Actually, that didn't got it. This got it.

,(?=([^\']*\'[^\']*\')*(?![^\']*\'))

Blessings to the fellow who created that expression, I don't know who
it was...

Cheers,
zdrakec