comp.lang.idl-pvwave archive: archive » Reading in date & time from csv file

Home » Public Forums » archive » Reading in date & time from csv file

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: Reading in date & time from csv file [message #88621 is a reply to message #88616]

Mon, 19 May 2014 08:27

Phillip Bitzer
Messages: 223
Registered: June 2006

Senior Member

On Sunday, May 18, 2014 3:25:45 PM UTC-5, justinclouds wrote:
>
> Can anybody help with what needs to be changed here to read this correctly or suggest an alternate method.
>
>

So, the problem seems to be READ_CSV doesn't seem to detect the first column is a string, correct?

IDL> f = 'test.txt'
IDL> data = READ_CSV(f)

IDL> help, data
** Structure <247e2b8>, 2 tags, length=64, data length=64, refs=1:
FIELD1 DOUBLE Array[4]
FIELD2 DOUBLE Array[4]
IDL> print, data.field1
2014.0000 2014.0000 2014.0000 2014.0000

Not sure why - but I don't use READ_CSV much.

Using READCOL works just fine, as I can specify the format of each column easily:
IDL> READCOL, f, date, val, FORMAT='A, F'

IDL> print, date
2014_05_12_18_39_33.194 2014_05_12_19_39_33.194 2014_05_12_20_39_33.194 2014_05_12_21_39_33.194

Then, you can use STR_SPLIT as Matt suggested...if you're on IDL 8. Otherwise, you'll have to get fancy with STREGEX.

----------------------
Here's the test file I used:
----------------------
2014_05_12_18_39_33.194, 1.0
2014_05_12_19_39_33.194, 2.0
2014_05_12_20_39_33.194, 3.0
2014_05_12_21_39_33.194, 4.0

Report message to a moderator

[Message index]

		Reading in date & time from csv file By: justinclouds on Sun, 18 May 2014 13:25
		Re: Reading in date & time from csv file By: Matthew Argall on Sun, 18 May 2014 16:31
		Re: Reading in date & time from csv file By: justinclouds on Sun, 18 May 2014 18:40
		Re: Reading in date & time from csv file By: Fabzi on Sun, 18 May 2014 23:59
		Re: Reading in date & time from csv file By: Matthew Argall on Mon, 19 May 2014 04:57
		Re: Reading in date & time from csv file By: justinclouds on Mon, 19 May 2014 08:37
		Re: Reading in date & time from csv file By: Phillip Bitzer on Mon, 19 May 2014 08:27
		Re: Reading in date & time from csv file By: justinclouds on Mon, 19 May 2014 08:39

Previous Topic:	hot pixels
Next Topic:	The refresh method and relative coordinate positioning

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Oct 08 20:10:51 PDT 2025

Total time taken to generate the page: 0.00706 seconds