First column cannot be populated

[zhezack]

csv data:

number,column_a,column_b
1,a,b
2,c,d
3,e,f`

my struct:

type Whatever struct{
     JustNumber   int     `csv:"number"`
     ColumnA      string  `csv:"column_a"`
     ColumnB      string  `csv:"column_b"`
}

the result will be:

{0   a   b}
{0   c   d}
{0   e   f}

but if csv data like this:

,number,column_a,column_b
,1,a,b
,2,c,d
,3,e,f`

the result will be:

{1   a   b}
{2   c   d}
{3   e   f}

why first column cannot be populate to struct?

[pikanezi]

Hello,

I just tried with this sample:

b := bytes.NewBufferString(`number,column_a,column_b
1,a,b
2,c,d
3,e,f`)
	var samples []Whatever
	if err := Unmarshal(b, &samples); err != nil {
		t.Fatal(err)
	}
	log.Println(samples)

and it prints [{1 a b} {2 c d} {3 e f}].

What method did you used?

[zhezack]

i read from file. If i read from string work correctly

os.OpenFile("sample.csv", os.O_RDWR, os.ModePerm)

[zhezack]

solved my csv file was wrong i dont know why.
thanks

[SirRamEsq]

I had a similar issue. For those who may be struggling, here was my situation/solution

I had exported a .csv file from MS Excel. I exported it out in UTF-8 format (or, so I thought). The file looked fine in Notepad++ at first glance, but gocsv would not find the first column.
Upon opening the .csv in Notepad++ and looking at the Encoding, I saw that it was not UTF-8, but UTF-8-BOM
Changing the Encoding to UTF-8 and saving the file allowed me to get the first column of .csv using gocsv

[bfitzsimmons]

@SirRamEsq I had this exact same issue. Thank you for sharing your solution!

[dewey]

Yep, it's the invisible BOM characters at the beginning of the file. I wrote this up in more detail here because I had the same problem with this library.