My data provider provides data in this format:
2008-01-02 06:00:00,1478.75,1480.25,1478.5,1480.0,2317
I have been going into the data file and replacing the space with a comma, but is there an easier way? Would it be possible to add a combined date/time field or is there a different way to do this?
Thanks!
2008-01-02 06:00:00,1478.75,1480.25,1478.5,1480.0,2317
I have been going into the data file and replacing the space with a comma, but is there an easier way? Would it be possible to add a combined date/time field or is there a different way to do this?
Thanks!
Rename
Yes, there's an easier way because the ASCII import is very versatile. Open WL8 Help > Data Manager > ASCII > Format options, then visit one of those links inside.
In particular, to import this format correctly you should have a single Date field (no Time added) and then type in or paste the following sequence:
yyyy-MM-dd HH:mm:ss
In particular, to import this format correctly you should have a single Date field (no Time added) and then type in or paste the following sequence:
yyyy-MM-dd HH:mm:ss
That worked! Thanks!
Your Response
Post
Edit Post
Login is required