{"id":645,"date":"2020-05-05T15:29:35","date_gmt":"2020-05-05T07:29:35","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=645"},"modified":"2020-05-05T15:54:56","modified_gmt":"2020-05-05T07:54:56","slug":"formatting-date-and-time-values-in-csv-files","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/05\/05\/formatting-date-and-time-values-in-csv-files\/","title":{"rendered":"Formatting date and time values in CSV files"},"content":{"rendered":"

Identifying the columns correctly<\/h2>\n

The first step in importing a CSV file into Easy Excel Analysis<\/a> is to ensure that each column is correctly identified.\u00a0 In this example, we will work with the sample CSV file:<\/p>\n

\"\"<\/p>\n

When we first open this file in Easy Excel Analysis<\/a> and click on the Preview<\/strong> button, an error is raised regarding the number of columns.<\/p>\n

\"\"<\/p>\n

Our CSV file encloses text in quotes, so we’ll need to select the Field values are quoted using “<\/strong> option (since we’re using double quotes as the quote character), and click Preview<\/strong> again:<\/p>\n

\"\"<\/p>\n

All the columns seem to be in order, so we can proceed.<\/p>\n

Adjusting the date format<\/h2>\n

On the next page, Easy Excel Analysis<\/a> has set up the date and time formats based on our computer’s settings.<\/p>\n

\"\"<\/p>\n

The date format is different from that in our CSV file:<\/p>\n

\"\"<\/p>\n

If we continue to the next step, our OrderDate<\/strong> column will be identified as a Text<\/strong> field, because the date format in the CSV file does not match our settings.<\/p>\n

\"\"<\/p>\n

Thus, we’ll need to change the date format settings accordingly.\u00a0 Go back to the previous step, and select the correct date format from the list of pre-defined formats, or enter the format manually.\u00a0 Note that d<\/strong> represents the date, m<\/strong> for month, and yyyy<\/strong> for the year.<\/p>\n

\"\"<\/p>\n

Once we have set up the date format to correctly match that in our CSV file, Easy Excel Analysis<\/a> will set up the OrderDate<\/strong> column as a Date and time<\/strong> column.<\/p>\n

\"\"<\/p>\n

If your date columns contain month names e.g.<\/p>\n

\"\"<\/p>\n

then just enter a blank value as the date format.\u00a0 Easy Excel Analysis<\/a> will then try to parse the value as best as it can.<\/p>\n

\"\"<\/p>\n

<\/h2>\n

Adjusting the time format<\/h2>\n

Adjusting the time format is similar to the steps described above for date formats.\u00a0 You can manually enter a format value if none of the listed formats match.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

Identifying the columns correctly The first step in importing a CSV file into Easy Excel Analysis is to ensure that each column is correctly identified.\u00a0 In this example, we will work with the sample CSV file: When we first open this file in Easy Excel Analysis and click on the Preview button, an error is […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[82],"tags":[83,84,85],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/645"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=645"}],"version-history":[{"count":4,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/645\/revisions"}],"predecessor-version":[{"id":663,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/645\/revisions\/663"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}