The "COLUMNS" qualifer will recognize dates.
http://ferret.pmel.noaa.gov/Ferret/documentation/users-guide/commands-reference/SET#_VPINDEXENTRY_1610
So, without any special /delimiter qualifier, the 01/01/00 etc will
be read in as dates. Although I have not checked how years of 00 are
translated; I think they will translate to 2000. Selvam, are those
intended to be year 2000, or year 0, or what? I would try,
columns/var="tvar, var"/type="date" read.txt
Then you could define a time axis from tvar and assign the data to
that time axis.
On 3/31/2014 10:01 PM, Akshay Hegde
wrote:
Try like this
[akshay@aix Desktop]$ f
NOAA/PMEL TMAP
FERRET v6.85
Linux 2.6.18-371.1.2.el5 64-bit - 11/12/13
1-Apr-14 10:25
yes? sp cat read.txt
01/01/00,0.966
01/02/00,0.944
01/03/00,0.874
01/04/00,0.940
01/05/00,1.914
01/06/00,3.046
01/07/00,3.172
01/08/00,2.706
01/09/00,1.656
yes? ! Reading as text/string
yes? columns/delim="\,"/type="text,numeric" read.txt
yes? sh d
currently SET data sets:
1> ./read.txt (default)
name title I J
K L M N
V1 V1 1:20480 ...
... ... ... ...
V2 V2 1:20480 ...
... ... ... ...
yes? list v1,v2
DATA SET: ./read.txt
X: 0.5 to 9.5
Column 1: V1
Column 2: V2
V1 V2
1 / 1: "01/01/00" 0.966
2 / 2: "01/02/00" 0.944
3 / 3: "01/03/00" 0.874
4 / 4: "01/04/00" 0.940
5 / 5: "01/05/00" 1.914
6 / 6: "01/06/00" 3.046
7 / 7: "01/07/00" 3.172
8 / 8: "01/08/00" 2.706
9 / 9: "01/09/00" 1.656
yes? ! reading all as numeric
where separator being comma and forward slash
yes? columns/delim="/,\,"/type="numeric,numeric,numeric,numeric"
read.txt
yes? list v1,v2,v3,v4
DATA SET: ./read.txt
X: 0.5 to 9.5
Column 1: V1
Column 2: V2
Column 3: V3
Column 4: V4
V1 V2 V3 V4
1 / 1: 1.000 1.000 0.0000 0.966
2 / 2: 1.000 2.000 0.0000 0.944
3 / 3: 1.000 3.000 0.0000 0.874
4 / 4: 1.000 4.000 0.0000 0.940
5 / 5: 1.000 5.000 0.0000 1.914
6 / 6: 1.000 6.000 0.0000 3.046
7 / 7: 1.000 7.000 0.0000 3.172
8 / 8: 1.000 8.000 0.0000 2.706
9 / 9: 1.000 9.000 0.0000 1.656
yes?
Regards,
Akshay Hegde,
Moderator,
The Unix and Linux Forum Users.
|