Who to make split for comma, but not for quoted commas in Java

Question

I need make split for commas on a String. But I need ignore commas inside the text fields

Input example:

'Field1','Field2','Field3, this field, has, multiples commas','Field4'

Output that I want:

'Field1'
'Field2'
'Field3, this field, has, multiples commas'
'Field4'

Output that I got:

'Field1'
'Field2'
'Field3
 this field,
 has,
 multiples commas'
'Field4'

Can some one help me?

vks · Accepted Answer · 2015-10-28T17:12:18.470

1

,(?=(?:[^']*'[^']*')*[^']*$)

You can split on this.See demo.

edited Oct 28 '15 at 17:12

answered Oct 27 '15 at 18:41

vks

This regex works on demo... But when i put it on split() method i got java.util.regex.PatternSyntaxException: Dangling meta character '*' near index 8. – brbrbr Oct 27 '15 at 18:49
Now its do split inside of the field3, and not between field3 and field4 =( – brbrbr Oct 28 '15 at 11:42
@Roqueirow see demo.it is working as expected – vks Oct 28 '15 at 17:12

1 Answers1