Scala: parse a csv line without using match/case

Question

We repeat the following code snippet to get the data from a csv line:

              val rowSplit = line.split(",",-1)
              rowSplit match {
                case array:Array[String] =>{
                  if (array.length > 23){
                    val (office,messageid,screenchannel,screenname) = 
(array(0),array(2),array(3), array(8))
                    ...

But it just stinks. Is there a better way to do this?

Chong Tang · Accepted Answer · 2015-06-16 13:55:26Z

1

It's not easy to handle CSV file properly. Fortunately, there are some libraries out there that you can use. I used one here: http://super-csv.github.io/super-csv/index.html, which is very good.

answered Jun 16, 2015 at 13:55

Chong Tang

2,14615 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gregor Raýman · Accepted Answer · 2015-06-16 13:49:00Z

0

First of all, note that a simple split by the separator is not a proper parsing of a general CSV file, as the values might be quoted and might contain commas.

But let's assume that in your case a comma is always a separator and the values are never quoted.

In such case you could use a regular expression to parse the CSV lines. Here a sample:

val LineRe = """([^,]*),([^,]*),([^,]*),([^,]*),([^,]*),([^,]*),([^,]*),([^,]*),.*""".r
line match {
  case LineRe(office, _, messageId, screenChannel1, _, _, _, _, screenName) => ...

answered Jun 16, 2015 at 13:49

Gregor Raýman

3,09115 silver badges19 bronze badges

Collectives™ on Stack Overflow

Scala: parse a csv line without using match/case

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related