| Re: filtering data data in .txt [message #92990 is a reply to message #92988] |
Tue, 05 April 2016 07:51   |
omar ali
Messages: 13
Registered: December 2015
|
Junior Member |
|
|
بتاريخ الثلاثاء، 5 أبريل، 2016 4:21:39 م UTC+2، كتب Jeremy Bailin:
> On Tuesday, April 5, 2016 at 10:12:24 AM UTC-4, omar ali wrote:
>> Hi,
>> I need to filter out the the rows having -9.999 values from the following data. I read the text file with opnr command but unfortunately, date and time are gone.
>>
>> Example of the file is below:
>>
>> 9/20/2007 10:00:00 1.88
>> 9/20/2007 11:00:00 1.88
>> 9/20/2007 12:00:00 1.88
>> 9/20/2007 13:00:00 1.88
>> 9/20/2007 14:00:00 1.88
>> 9/20/2007 15:00:00 1.88
>> 9/20/2007 16:00:00 1.86
>> 9/20/2007 17:00:00 1.86
>> 9/20/2007 18:00:00 1.83
>> 9/20/2007 19:00:00 -9.999
>> 9/20/2007 20:00:00 -9.999
>> 9/20/2007 21:00:00 -9.999
>> 9/20/2007 22:00:00 -9.999
>> 9/20/2007 23:00:00 -9.999
>> 9/21/2007 0:00:00 -9.999
>> 9/21/2007 1:00:00 -9.999
>> 9/21/2007 2:00:00 -9.999
>> 9/21/2007 3:00:00 -9.999
>> 9/21/2007 4:00:00 -9.999
>> 9/21/2007 5:00:00 -9.999
>> 9/21/2007 6:00:00 -9.999
>> 9/21/2007 7:00:00 -9.999
>> 9/21/2007 8:00:00 -9.999
>> 9/21/2007 9:00:00 -9.999
>> 9/21/2007 10:00:00 1.81
>> 9/21/2007 11:00:00 1.81
>> 9/21/2007 12:00:00 1.81
>> 9/21/2007 13:00:00 1.83
>> 9/21/2007 14:00:00 1.83
>
> I would recommend using WHERE.
>
> -Jeremy.
the problem is not using where. actually, it is the format of the first and secound columns. I do not know how to read and write such format. I usually a text with the following command which is not appropriate since it save the data into float array.
Thanks
Code for reading txt file
--------------------------
asc_org="D:\data\file.txt"
openr,8,asc_org
r_org=fltarr(1,78840) ; change based on the dimension of the txt file
readf,8,r_org
close,8
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
