Scala Fully Parse CSV lines from a File, supports ignoring commans in quoted strings. Can generate a JSON DTO.

parseCSV.scala

   package dtos

import play.api.libs.json.{Format, Json}

case class ITableRow(
                    cols: Seq[String]
                    )

object ITableRow {
  implicit val jsonFormatter: Format[ITableRow] = Format(Json.reads[ITableRow], Json.writes[ITableRow])
}

// AND
package dtos

import play.api.libs.json.{Format, Json}

case class ITable(
                 rows: Seq[ITableRow]
                 )

object ITable {
  implicit val jsonFormatter: Format[ITable] = Format(Json.reads[ITable], Json.writes[ITable])
}

// AND Use the following snip in your code

   // -----------------------------------------------------------------------
   
   val lines = Files.readAllLines(Paths.get(uri)).asScala

    val parseCsvLine = (line: String) => {

      var v = Vector.empty[String]

      var inQuote = false
      var s = ""

      for(c:Char <- line.toCharArray) {
        if (c == '"') {
          inQuote = !inQuote
        } else {
          if (c == ',' && !inQuote) {
            if (s == "") {
              s = "&nbsp;"
            }
            v = v :+ s
            s = ""
          } else {
            if (s.contains("________")) {
              s = "________"
            }
            s += c
          }
        }
      }
      v = v :+ s
      v
    }

    val rows = lines.map(line => {
      val l = parseCsvLine(line)
      ITableRow(l)
    })

    ITable(rows)