I have data in the following format:
date,open,high,low,close,volume
2019-06-05T09:27:00Z,19.334,19.334,19.334,19.334,61
2019-06-05T09:28:00Z,19.334,19.334,19.334,19.334,0
2019-06-05T09:29:00Z,19.334,19.334,19.334,19.334,0
2019-06-05T09:30:00Z,19.334,19.334,19.334,19.334,0
I've tried various alternatives but WL isn't happy with the "T" and "Z" in the date/time string. Any suggestions on how to set up the New DataSet dialog so it accepts the date/time format in my file v gratefully received. Thx
date,open,high,low,close,volume
2019-06-05T09:27:00Z,19.334,19.334,19.334,19.334,61
2019-06-05T09:28:00Z,19.334,19.334,19.334,19.334,0
2019-06-05T09:29:00Z,19.334,19.334,19.334,19.334,0
2019-06-05T09:30:00Z,19.334,19.334,19.334,19.334,0
I've tried various alternatives but WL isn't happy with the "T" and "Z" in the date/time string. Any suggestions on how to set up the New DataSet dialog so it accepts the date/time format in my file v gratefully received. Thx
Rename
Just type in yyyy-MM-ddTHH:mm:ssZ for the Date field.
Awesome - many thanks. I was wrongly assuming that you had to split the date and time across the two fields in the dialog.
That works perfectly and will also help in the future. Much appreciated.
That works perfectly and will also help in the future. Much appreciated.
QUOTE:
I was wrongly assuming that you had to split the date and time across the two fields in the dialog.
You would do it when a data vendor splits the date and time portions across two distinct columns.
Thx - understood
Your Response
Post
Edit Post
Login is required