Parse CSV with double quote in some cases

by

You could use Matcher.find with the following regular expression:

\s*("[^"]*"|[^,]*)\s*

Here’s a more complete example:

String s = "a1, a2, a3, \"a4,a5\", a6";
Pattern pattern = Pattern.compile("\\s*(\"[^\"]*\"|[^,]*)\\s*");
Matcher matcher = pattern.matcher(s);
while (matcher.find()) {
    System.out.println(matcher.group(1));
}

See it working online: ideone

More Related Contents:

  1. Can you recommend a Java library for reading (and possibly writing) CSV files? [closed]
  2. Fast CSV parsing
  3. How to read XML using XPath in Java
  4. Parse a URI String into Name-Value Collection
  5. “Expected BEGIN_OBJECT but was STRING at line 1 column 1”
  6. How can I efficiently parse HTML with Java?
  7. How to parse JSON in Java
  8. Read CSV with Scanner()
  9. Date object SimpleDateFormat not parsing timestamp string correctly in Java (Android) environment
  10. Parsing JSON array into java.util.List with Gson
  11. Custom JSON deserializer using Gson
  12. How to decode JSON with unknown field using Gson?
  13. Parsing JSON string in Java
  14. CSV parsing in Java – working example..? [closed]
  15. Using Joda Date & Time API to parse multiple formats
  16. Java 8 LocalDateTime is parsing invalid date
  17. Parsing PDF files (especially with tables) with PDFBox
  18. Java: CSV File Easy Read/Write
  19. “Content is not allowed in prolog” when parsing perfectly valid XML on GAE
  20. Parsing a fixed-width formatted file in Java
  21. Parsing CSV in java
  22. How can I parse this JSON in Android?
  23. setting a UTF-8 in java and csv file [duplicate]
  24. Reading HTML file to DOM tree using Java
  25. OpenCSV – How to map selected columns to Java Bean regardless of order?
  26. Parse String date in (yyyy-MM-dd) format
  27. XML data to PostgreSQL database [closed]
  28. How to get the number of columns from a JDBC ResultSet?
  29. Using gson to deserialize specific JSON field of an object
  30. Create and download CSV file in a Java servlet

Leave a Comment