无法使用golang读取csv文件中的json str

Question

I export mysql data to a csv file, and there is one field use json string

when i use "encoding/csv" read this file, it show "wrong number of fields in line"

but when i delete the field, it's ok

like this: code example

is anyway to solve this?

Answer 1

You botched up quoting. To quote a " in CSV your preceed it with one more double quote (and not with backlashes):

id,name
42,"Henry Walton ""Indiana"" Jones Jr."