split string with csv file golang

Question

I'm trying to extract a date from an excel spreadsheet, I managed to give a log where it shows the entire date, I wanted to know how to extract only the month, for example, in this case it's "log.Println("DT REFER", emp. DT_REFER" the DT_REFER is where the date is in the spreadsheet, how can I get only the month out of it? the format that came was this. DT REFER 2011-03-31

Please provide enough code so others can better understand or reproduce the problem. — Community
– Community Bot, Commented Feb 28, 2022 at 0:45

Lakshya Singh · Accepted Answer · 2022-02-27 13:09:39Z

1

You can use fmt.Sscanf to extract the month out of the log string that you have. Given you have a fixed string structure that you can match against as follows:

// if emp.DT_REFER isn't string use Sprint to make it string
s := fmt.Sprint(emp.DT_REFER)
y, m, d := 0, 0, 0
fmt.Sscanf(s, "%d-%d-%d", &y, &m, &d)
fmt.Println(y, m, d)

edited Feb 27, 2022 at 13:09

answered Feb 25, 2022 at 11:48

Lakshya Singh

4724 silver badges6 bronze badges

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

2 Comments

wellerson Over a year ago

the problem is that it is getting it from a csv file inside the DT_REFER, I wanted to know how to get only the month out of it

Lakshya Singh Over a year ago

I have updated the answer to consider we need to take out month from DT_REFER itself.

Collectives™ on Stack Overflow

split string with csv file golang

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related