Search Results

Thanks alot for your help. This is pretty close, but I think this gets tricky if you select fields based on rows/fields (which is what you are doing). Here you are picking 2nd Saturday of Mar and 1...

If the date is in DST (ie between 2nd Sunday of Mar and 1 sunday of November, both inclusive) then the function should return 1, else 0.

Is there a way to figure out if given date is in DST or in EST? So imagine a shell script is_date_dst.sh

sh is_date_dst.sh 2009-03-02 would return 0 and
sh is_date_dst.sh 2009-03-22 would return...

Scottn,

thanks for your reply. It pretty much does the work. But I noticed two issues:

1) All the delimiters in the file "," are gone!

2) I see why you need to replace "/" with an "_" since...

I have a file containing date/time sorted data of the form
...
2009/06/10,20:59:59.950,XAG/USD,Q,1,1115, 14.3025,100,1,1
2009/06/10,20:59:59.950,XAG/USD,Q,1,1116, 14.3026,125,1,1...