所以我拿了一些公開的數(shù)據(jù)，看起來像這樣——這是文件http://expirebox.com/download/b149b744768fb11aee9c5e26ad409bcc.html,,,% of Total Expenditure,,,Function Code,Type of Activity,Expenditure,Dollars/Student (ADA),"This District (ADA 49,497)",All Unified School Districts,Statewide Average1000-1999êê,INSTRUCTIONêê,"$249,397,226","$5,039",42%,62%,62%1000,Instruction,"$247,472,790êê","$5,000",42%,48%,49%1110,Special Education: Separate Classes,"$1,004,074",$20,N/A,N/A,N/A1120,Special Education: Resource Specialist Instruction,"$781,629",$16,N/A,N/A,N/A1130,Special Education: Supplemental Aids & Services in Regular Classrooms,"$46,747",$1,N/A,N/A,N/A1180,Special Education: Nonpublic Agencies/Schools (NPA/S),N/A,N/A,N/A,N/A,N/A1190,Special Education: Other Specialized Instructional Services,"$91,985",$2,N/A,N/A,N/A1100-1199,Instruction - Special Education,"$1,924,436êê",$39,0%,14%,13%它在一個(gè)csv中。我試過這個(gè)代碼file, err := os.Open("expenses.csv")if err != nil { log.Fatal(err)}defer file.Close()scanner := bufio.NewScanner(file)for scanner.Scan() { fmt.Println(scanner.Text())}if err := scanner.Err(); err != nil { log.Fatal(err)}和這個(gè)content, err := ioutil.ReadFile("expenses.csv")lines := strings.Split(string(content), "\n")fmt.Println(lines)check(err)dat, err := os.Open("expenses.csv")check(err)defer dat.Close()reader := csv.NewReader(dat)reader.LazyQuotes = truereader.FieldsPerRecord = -1rawCSVData, err := reader.ReadAll()check(err)fmt.Println(rawCSVData)for _, each := range rawCSVData { fmt.Println(each)}檢查在哪里func check(e error) { if e != nil { panic(e) }}在這兩種情況下，我都得到了這個(gè)結(jié)果 -"Total Expenditures, All Activities",,"$594,788,926","$12,017",100%,100%,100%,1%15%,4%,4%AA,N/A,N/Anified School Districts,Statewide Average而不是所有的行。為什么我只看最后一行？
1 回答
夢(mèng)里花落0921
TA貢獻(xiàn)1772條經(jīng)驗(yàn) 獲得超6個(gè)贊
基本問題是這個(gè)文件有\(zhòng)r行尾。它也不是有效的 UTF-8。總之，這些都會(huì)造成Scanner很多麻煩。
首先，我們可以使用 xxd
00000000: 2c2c 2c25 206f 6620 546f 7461 6c20 4578 ,,,% of Total Ex
00000010: 7065 6e64 6974 7572 652c 2c2c 0d46 756e penditure,,,.Fun
如果你看，你會(huì)看到行結(jié)尾是0d，也就是\r。Scanner需要它是\r\n或\n。
接下來，您可能會(huì)遇到麻煩，因?yàn)樗皇?UTF-8。ê那里的所有內(nèi)容都是 real 0xCA，這不是有效的 UTF-8 編碼。我們可以xxd再次看到：
000000b0: 3939 39ca ca2c 494e 5354 5255 4354 494f 999..,INSTRUCTIO
000000c0: 4eca ca2c 2224 3234 392c 3339 372c 3232 N..,"$249,397,22
Go 可能只會(huì)將它作為字節(jié)（和 get ê）發(fā)送，這是許多編輯器嘗試做的事情，但它可能會(huì)引起麻煩。
如果可能，請(qǐng)重新格式化此文件以使用 UTF-8 中的 Unix 或 Windows 行結(jié)尾。
- 1 回答
- 0 關(guān)注
- 881 瀏覽
添加回答
舉報(bào)
0/150
提交
取消