【问题】
I have a csv records with timestamps like or every 5 minutes:
- 2015/05/19 16:15:00 - 2015/05/19 16:20:00 - 2015/05/19 16:35:00 - 2015/05/19 16:10:00 - 2015/05/19 16:55:00
I’m using an array to compare if the dates per record is within 15 minutes:
ArrayList<String> per15Min = new ArrayList<String>() { { add("00,15"); add("15,30"); add("30,45"); add("45,00"); }};
What I do is read each record, split it based on “,” to extract the Dates:
private SimpleDateFormat csvDateFormat = new SimpleDateFormat("yyyy/MM/dd HH🇲🇲ss"); private SimpleDateFormat fileDateFormat = new SimpleDateFormat("yyyyMMddHHmm"); // Loop thru each record while ((perLine = br.readLine()) != null) { // Store date per record in a string String[] perColumn = perLine.split(",", -1); String date = perColumn[0];