Golang enclosure rule for csv parsing

Question

I have the following problem. I have to read csv files that are delimited by '|', and some fields have large json strings in which some contain '|'. The fields are enclosed in single-quotes. How can I specify in GOLANG that the fields are enclosed in single quotes.

This is how it is setup right now:

fx := csv.NewReader(fz)

fx.Comma = '|'
fx.LazyQuotes = true
fx.FieldsPerRecord = 16

I don't see anything in GODOCS options for enclosure rules. Does anyone have a workaround for this ?

OneOfOne · Accepted Answer · 2014-07-31 15:05:23Z

5

You can't, however, luckily Go is written in, well, Go.

You could copy $GOROOT/src/pkg/encoding/csv/reader.go, then modify line 274, 289, 297 and 303 to use '\'' instead of '"' and you're good to go.

answered Jul 31, 2014 at 15:05

OneOfOne

100k22 gold badges195 silver badges187 bronze badges

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

6 Comments

dan89 Over a year ago

Good to know! But I can't do this in production :D

OneOfOne Over a year ago

Why not? you can copy it to your own package and use it just fine. instead of import "encoding/csv" use import "your-project-path/csv".

dan89 Over a year ago

Yes, it works! But I feel kind of awkward doing this :))

fuz Over a year ago

I think I'm going to make a feature request about this.

fuz Over a year ago

Here it is: code.google.com/p/go/issues/…

|

Collectives™ on Stack Overflow

Golang enclosure rule for csv parsing

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related