Use Scala parser combinator to parse CSV files

by

What you missed is whitespace. I threw in a couple bonus improvements.

import scala.util.parsing.combinator._

object CSV extends RegexParsers {
  override protected val whiteSpace = """[ \t]""".r

  def COMMA   = ","
  def DQUOTE  = "\""
  def DQUOTE2 = "\"\"" ^^ { case _ => "\"" }
  def CR      = "\r"
  def LF      = "\n"
  def CRLF    = "\r\n"
  def TXT     = "[^\",\r\n]".r

  def file: Parser[List[List[String]]] = repsep(record, CRLF) <~ opt(CRLF)
  def record: Parser[List[String]] = rep1sep(field, COMMA)
  def field: Parser[String] = (escaped|nonescaped)
  def escaped: Parser[String] = (DQUOTE~>((TXT|COMMA|CR|LF|DQUOTE2)*)<~DQUOTE) ^^ { case ls => ls.mkString("")}
  def nonescaped: Parser[String] = (TXT*) ^^ { case ls => ls.mkString("") }

  def parse(s: String) = parseAll(file, s) match {
    case Success(res, _) => res
    case _ => List[List[String]]()
  }
}

More Related Contents:

  1. Import CSV file with mixed data types
  2. The Possibility of a “True” Quiz Generator [closed]
  3. Parse error: syntax error, unexpected T_STRING in app/design/frontend/base/default/template/catalog/product/new.phtml on line 37 [closed]
  4. Writing a parser like Flex/Bison that is usable on 8-bit embedded systems
  5. Read .csv file in C
  6. Can you recommend a Java library for reading (and possibly writing) CSV files? [closed]
  7. How to parse freeform street/postal address out of text, and into components
  8. What is the difference between an Abstract Syntax Tree and a Concrete Syntax Tree?
  9. sort csv by column
  10. Parse Delimited CSV in .NET
  11. Get and Parse CSV file in android
  12. Specifying the filename when saving a DataFrame as a CSV [duplicate]
  13. lexers vs parsers
  14. How does the ANTLR lexer disambiguate its rules (or why does my parser produce “mismatched input” errors)?
  15. How do I efficiently parse a CSV file in Perl?
  16. Handling extra operators in Shunting-yard
  17. Parse CSV with double quote in some cases
  18. How do I export html table data as .csv file?
  19. How can error reporting in grammars be improved?
  20. Difference between constituency parser and dependency parser
  21. Looking for a clear definition of what a “tokenizer”, “parser” and “lexers” are and how they are related to each other and used?
  22. Parsing XML using unix terminal
  23. Problem with parse a LocalDateTime using java 8
  24. How to identify whether a grammar is LL(1), LR(0) or SLR(1)?
  25. Is it a Lexer’s Job to Parse Numbers and Strings?
  26. How to manually parse a floating point number from a string
  27. Parse URL in shell script
  28. Parse clock time in java 8
  29. Parse CSV file in C [closed]
  30. Parsing a pipe-delimited file in Python

Leave a Comment