Golang : Skip blank/empty lines in CSV file and trim whitespaces example
Problem:
Your Golang program is reading from a CSV file and you want to skip blank lines in the CSV file. Also, you want to trim whitespaces in the final output. How to do that?
Solution:
After initiating the csv.Read()
or csv.NewReader()
functions. Set the reader's FieldsPerRecord
and TrimLeadingSpace
to:
csvReader.FieldsPerRecord = -1 // optional
csvReader.TrimLeadingSpace = true
The CSV reader will automagically ignore those empty lines.
Here you go!
package main
import (
"encoding/csv"
"fmt"
"io"
"log"
"strings"
)
func main() {
csvDataWithEmptyLines := `first_name,last_name,username
"Adam","Sandler", adam
Steve, McQueen,steve
"Robert","Spacey","robspacy"
`
csvReader := csv.NewReader(strings.NewReader(csvDataWithEmptyLines))
// add these
csvReader.FieldsPerRecord = -1
csvReader.TrimLeadingSpace = true
for {
record, err := csvReader.Read()
if err == io.EOF {
break
}
if err != nil {
log.Fatal(err)
}
fmt.Println(record)
}
}
Output:
// properly formatted and look nice
[firstname lastname username]
[Adam Sandler adam]
[Steve McQueen steve]
[Robert Spacey robspacy]
References:
See also : Golang : How to read CSV file
By Adam Ng
IF you gain some knowledge or the information here solved your programming problem. Please consider donating to the less fortunate or some charities that you like. Apart from donation, planting trees, volunteering or reducing your carbon footprint will be great too.
Advertisement
Tutorials
+14.1k Golang : Validate hostname
+3.9k Which content-type(MIME type) to use for JSON data
+8.7k Golang : Identifying Golang HTTP client request
+9.7k Golang : Fix - does not implement sort.Interface (missing Len method)
+6.4k Golang : Example of how to detect which type of script a word belongs to
+5.2k Golang : Selection sort example
+26.8k Golang : Connect to database (MySQL/MariaDB) server
+19.1k Golang : How to force compile or remove object files first before rebuild?
+15.5k Golang : Merge video(OpenCV) and audio(PortAudio) into a mp4 file
+18k Mac OSX : Homebrew and Golang
+46.2k Golang : How to convert JSON string to map and slice
+15.2k Golang : Fix cannot convert buffer (type *bytes.Buffer) to type string error