Re: [ferret_users] how to map date strings from a csv file onto a ferret time axis

[William Kessler <william.s.kessler@xxxxxxxx>]

CSV is a pain!

I have done this kind of thing once, using a unix shell script to sort and extract each variable, writing each variable into (separate) files that Ferret can read. Yes, a pain!!!

I've attached the shell script as an example. If there aren't too many values, and if they are more or less regular in the csv file, it might be possible to do this kind of thing in a text editor.

Billy


> On Jan 31, 2022, at 1:44 PM, Albert Hermann - NOAA Affiliate <albert.j.hermann@xxxxxxxx> wrote:
> 
> Hi,
> Does anyone know how to easily map dates like the ones shown below (contained as a variable in a csv file) onto a time axis in ferret? The file contains one date string and temperature value (plus other variables) per line. So far I have not found any ferret function that can interpret these strings - does one exist? Thanks.
> -Al Hermann
> 
> 
> yes? list/i=1:10 time
>              VARIABLE : TIME
>              FILENAME : 2021_SpringDeployed_BS_BioPUFFS_POPS0001_bottomdata.csv
>              SUBSET   : 10 points (X)
>  1    /  1:"2021-05-13T00:10:00Z"
>  2    /  2:"2021-05-13T01:10:00Z"
>  3    /  3:"2021-05-13T02:10:00Z"
>  4    /  4:"2021-05-13T03:10:00Z"
>  5    /  5:"2021-05-13T04:10:00Z"
>  6    /  6:"2021-05-13T05:10:00Z"
>  7    /  7:"2021-05-13T06:10:00Z"
>  8    /  8:"2021-05-13T07:10:00Z"
>  9    /  9:"2021-05-13T08:10:00Z"
>  10   / 10:"2021-05-13T09:10:00Z"
> 
> -- 
> albert.j.hermann@xxxxxxxx
> Pacific Marine Environmental Laboratory
> 7600 Sand Point Way NE
> Seattle WA 98115
> 206-526-6495

Attachment: convert_ADCP_csv_files_to_readable
Description: Binary data