Regular expressions and delimiters

Asked Oct 10 '16 at 20:08

Active Oct 10 '16 at 20:28

Viewed 36 times

So I am reading in a file that it divided by commas but some comma's are inside parenthesis. Something like the following.

15000,"111,0000",16000

I am using the delimiter but I don't want the delimiter "," to count the comma that is in the parenthesis. I have looked up similar problems but they say just use a regular expression or regex and it doesn't explain how they work and I don't know how they are suppose to work with a delimiter.

edited Oct 10 '16 at 20:28

Guillaume Jacquenot

11,217
6
43
49

asked Oct 10 '16 at 20:08

JacksonHP

2

Use a CSV parser. What is the language you are coding in? – Wiktor Stribiżew Oct 10 '16 at 20:09
java sorry I should have included that – JacksonHP Oct 10 '16 at 20:12
Check https://commons.apache.org/proper/commons-csv/apidocs/org/apache/commons/csv/CSVParser.html – Wiktor Stribiżew Oct 10 '16 at 20:14
Or a dup of http://stackoverflow.com/questions/18893390/splitting-on-comma-outside-quotes if java is your language. – Bohemian Oct 10 '16 at 20:24

Regular expressions and delimiters

0 Answers0