Cool looking data...
I do this sort of thing a lot and usually use the wonderful 'awk' program to massage the data before reading it onto Pd. For this particular file it could be
awk '/:00/ {print $5}'
(etc).
cheers Miller
On Sun, Sep 23, 2012 at 11:26:22PM +0200, umberto torrez wrote:
Hi list, i need to load .txt files with data into tables.
But my .txt file is not forrmated and theres some texts i need to get rid from my files:
my .txt looks like this:
Format IAGA-2002 | Source of Data Institute of Geophysics NAS of Ukraine | Station Name Kiev Dymer | IAGA CODE KIV | Geodetic Latitude 50.700 | Geodetic Longitude 30.300 | Elevation | Reported XYZF | Sensor Orientation | Digital Sampling | Data Interval Type 1-minute | Data Type variation | # This data file was created using INTERMAGNET data | # from the Edinburgh GIN. These data were acquired | # from an INTERMAGNET reported data file. | # Final data will be available on the INTERMAGNET DVD | # Go to www.intermagnet.org for details on obtaining this product. | # CONDITIONS OF USE: The conditions of use for data provided | # through INTERMAGNET and acknowledgement templates can be found | # at www.intermagnet.org | DATE TIME DOY KIVX KIVY KIVZ KIVF | 2011-08-22 00:00:00.000 234 19201.70 2411.10 46524.20 99999.00 2011-08-22 00:01:00.000 234 19201.50 2411.20 46524.20 99999.00 2011-08-22 00:02:00.000 234 19201.50 2411.20 46524.30 99999.00 2011-08-22 00:03:00.000 234 19201.40 2411.20 46524.30 99999.00 2011-08-22 00:04:00.000 234 19201.30 2411.20 46524.30 99999.00 2011-08-22 00:05:00.000 234 19201.20 2411.00 46524.40 99999.00 2011-08-22 00:06:00.000 234 19201.10 2410.80 46524.50 99999.00 2011-08-22 00:07:00.000 234 19201.00 2411.00 46524.50 99999.00 2011-08-22 00:08:00.000 234 19201.00 2411.20 46524.40 99999.00 2011-08-22 00:09:00.000 234 19201.10 2411.40 46524.30 99999.00 2011-08-22 00:10:00.000 234 19201.10 2411.60 46524.30 99999.00 2011-08-22 00:11:00.000 234 19201.00 2411.70 46524.30 99999.00 2011-08-22 00:12:00.000 234 19201.10 2411.70 46524.30 99999.00 2011-08-22 00:13:00.000 234 19201.20 2412.00 46524.30 99999.00 2011-08-22 00:14:00.000 234 19201.30 2411.90 46524.40 99999.00
and so on....
I just need to load the 3 last colums into tables starting at line 20.
Is it possible to tell pd to load just specific specific part of my .txt file? or which is the best approach for this?
I can copy the data by hand but since i have tons of .txt files im looking for an automatic way of doing this.
cheers
Umberto.
Pd-list@iem.at mailing list UNSUBSCRIBE and account-management -> http://lists.puredata.info/listinfo/pd-list