Sponsored Content
Full Discussion: awk array problem
Top Forums Shell Programming and Scripting awk array problem Post 302541206 by cmp260 on Friday 22nd of July 2011 06:34:16 PM
Old 07-22-2011
hi,
the bird rejection time is not raw datalogger time since that is minus 16 hours from the actual time, it is 8am to 5pm corrected time. I suppose we could get really fancy and reference an array or lookup table of daily sunrise/sunset at partiular lattitude! -but probably easier to change the times manually for every 4 month data run...

something like this for csv would be sufficent for graphing:
2011-07-17, 261, 22:01:32
2011-07-18, 217, 08:07:31

presumably just modification the format of the output, no?

however, how do I go about ading A+X and b+d for the final in out daily stats?

Last edited by cmp260; 07-28-2011 at 06:28 PM.. Reason: more info
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk array problem

hi i am trying to perform some calculations with awk and arrays. i have this so far: awk 'NR==FNR{ for(i=1; i<=NF; i++) {array+=$i} tot++;next} {for(i=1; i<=NF; i++) {avg=array/tot} {diff=(array - avg)}} {for(i=1; i<=NF; i++) {printf("%5.8f\n",diff)}}' "$count".txt "$count".ttt >... (4 Replies)
Discussion started by: npatwardhan
4 Replies

2. Shell Programming and Scripting

Problem with lookup values on AWK associative array

I'm at wits end with this issue and my troubleshooting leads me to believe it is a problem with the file formatting of the array referenced by my script: awk -F, '{if (NR==FNR) {a=$4","$3","$2}\ else {print a "," $0}}' WBTSassignments1.txt RNCalarms.tmp On the WBTSassignments1.txt file... (2 Replies)
Discussion started by: JasonHamm
2 Replies

3. Shell Programming and Scripting

AWK Array problem

Dear All, I am facing problem to get right output through awk program I have file in which “B” value is appearing multiple time and I need to capture all these values. My script is BEGIN { FS=" " } { if ( substr($1,1,5) == "START" ) { i =... (2 Replies)
Discussion started by: arvindng
2 Replies

4. Shell Programming and Scripting

AWK help. how to compare a variable with a data array in AWK?

Hi all, i have a data array as follows. array=ertfgj2345 array=456ttygkd . . . array=errdjt3235 so number or elements in the array can varies depending on how big the data input is. now i have a variable, and it is $1 (there are $2, $3 and so on, i am only interested in $1). ... (9 Replies)
Discussion started by: usustarr
9 Replies

5. Shell Programming and Scripting

Challenging Awk array problem

Hi, I rather have a very complicated awk problem here, at least to me. I have two files. File 1: 607 687 174 0 0 chr1 3000001 3000156 -194195276 - L1_Mur2 LINE L1 -4310 1567 1413 1 607 917 214 114 45 chr1 3000237 ... (19 Replies)
Discussion started by: polsum
19 Replies

6. Shell Programming and Scripting

Using awk array problem

I am trying to map values in the input file, where 2nd column depends on the specific value in the 1st column. When 1st column is A place 1 into 2nd column, when it is B, place 2, when C place 3, otherwise no change. My input: U |100|MAIN ST |CLMN1|1 A |200|GREEN LN |CLMN2|2 1 |12... (4 Replies)
Discussion started by: migurus
4 Replies

7. Shell Programming and Scripting

HELP with AWK one-liner. Need to employ an If condition inside AWK to check for array variable ?

Hello experts, I'm stuck with this script for three days now. Here's what i need. I need to split a large delimited (,) file into 2 files based on the value present in the last field. Samp: Something.csv bca,adc,asdf,123,12C bca,adc,asdf,123,13C def,adc,asdf,123,12A I need this split... (6 Replies)
Discussion started by: shell_boy23
6 Replies

8. Shell Programming and Scripting

Problem with awk array when loading from shell variable

Hi, I have a problem with awk array when iam trying to use awk in solaris box as below..Iam unable to figure out the problem.. Need your help. is there any alternative to make it in arrays from variable values nawk 'BEGIN {SUBSEP=" "; split("101880|110045 101887|110045 101896|110045... (9 Replies)
Discussion started by: cskumar
9 Replies

9. Shell Programming and Scripting

How to Assign an shell array to awk array?

Hello All, Can you please help me with the below. #!/bin/bash ARR="No Differences In Stage Between HASH_TOTALS & HASH_TOTALS_COMP For UNINUM:0722075 PROVIDER:5 EXTRACT_DT:30-SEP-12 VER_NUM:1" ARR="No Differences In Stage Between HASH_TOTALS & HASH_TOTALS_COMP For UNINUM:0722075 PROVIDER:5... (14 Replies)
Discussion started by: Ariean
14 Replies

10. Shell Programming and Scripting

Index problem in associate array in awk

I am trying to reformat the table by filling any missing rows. The final table will have consecutive IDs in the first column. My problem is the index of the associate array in the awk script. infile: S01 36407 53706 88540 S02 69343 87098 87316 S03 50133 59721 107923... (4 Replies)
Discussion started by: yifangt
4 Replies
DateTime::Event::Sunrise(3pm)				User Contributed Perl Documentation			     DateTime::Event::Sunrise(3pm)

NAME
DateTime::Event::Sunrise - Perl DateTime extension for computing the sunrise/sunset on a given day SYNOPSIS
use DateTime; use DateTime::Event::Sunrise; my $dt = DateTime->new( year => 2000, month => 6, day => 20, ); my $sunrise = DateTime::Event::Sunrise ->sunrise ( longitude =>'-118', latitude =>'33', altitude => '-0.833', iteration => '1' ); my $sunset = DateTime::Event::Sunrise ->sunset ( longitude =>'-118', latitude =>'33', altitude => '-0.833', iteration => '1' ); my $tmp_rise = $sunrise->next( $dt ); my $dt2 = DateTime->new( year => 2000, month => 12, day => 31, ); # iterator my $dt_span = DateTime::Span->new( start =>$dt1, end=>$dt2 ); my $set = $sunrise->intersection($dt_span); my $iter = $set->iterator; while ( my $dt = $iter->next ) { print ' ',$dt->datetime; } # is it day or night? my $day_set = DateTime::SpanSet->from_sets( start_set => $sunrise, end_set => $sunset ); print $day_set->contains( $dt ) ? 'day' : 'night'; my $dt = DateTime->new( year => 2000, month => 6, day => 20, time_zone => 'America/Los_Angeles', ); my $sunrise = DateTime::Event::Sunrise ->new( longitude =>'-118' , latitude => '33', altitude => '-0.833', iteration => '1' ); my $tmp = $sunrise->sunrise_sunset_span($dt); print "Sunrise is:" , $tmp->start->datetime , " "; print "Sunset is:" , $tmp->end->datetime; my $dt1 = $sunrise->sunrise_datetime( $dt ); print "Sunrise is:" , $dt1->datetime , " "; my $dt2 = $sunrise->sunset_datetime( $dt ); print "Sunset is:" , $dt2->datetime , " "; DESCRIPTION
This module will return a DateTime recurrence set for sunrise or sunset. METHODS
sunrise, sunset, sunrise_sunset_span, sunrise_datetime, sunset_datetime my $sunrise = DateTime::Event::Sunrise ->sunrise ( longitude => '-118', latitude => '33', altitude => '-0.833', iteration => '1' ); my $sunset = DateTime::Event::Sunrise ->sunset ( longitude => '-118', latitude => '33', altitude => '-0.833', iteration => '1' ); my $sunrise_span = DateTime::Event::Sunrise ->new ( longitude => '-118', latitude => '33', altitude => '-0.833', iteration => '1' ); my $both_times = $sunrise_span->sunrise_sunset_span($dt); print "Sunrise is:" , $both_times->start->datetime; print "Sunset is:" , $both_times->end->datetime; my $dt1 = $sunrise->sunrise_datetime( $dt ); print "Sunrise is:" , $dt1->datetime , " "; my $dt2 = $sunrise->sunset_datetime( $dt ); print "Sunset is:" , $dt2->datetime , " "; Eastern longitude is entered as a positive number Western longitude is entered as a negative number Northern latitude is entered as a positive number Southern latitude is entered as a negative number Iteration is set to either 0 or 1. If set to 0 no Iteration will occur. If set to 1 Iteration will occur. Default is 0. There are a number of sun altitudes to chose from. The default is -0.833 because this is what most countries use. Feel free to specify it if you need to. Here is the list of values to specify altitude (Altitude) with: * 0 degrees Center of Sun's disk touches a mathematical horizon * -0.25 degrees Sun's upper limb touches a mathematical horizon * -0.583 degrees Center of Sun's disk touches the horizon; atmospheric refraction accounted for * -0.833 degrees Sun's supper limb touches the horizon; atmospheric refraction accounted for * -6 degrees Civil twilight (one can no longer read outside without artificial illumination) * -12 degrees Nautical twilight (navigation using a sea horizon no longer possible) * -15 degrees Amateur astronomical twilight (the sky is dark enough for most astronomical observations) * -18 degrees Astronomical twilight (the sky is completely dark) Notes on Iteration The original method only gives an approximate value of the Sun's rise/set times. The error rarely exceeds one or two minutes, but at high latitudes, when the Midnight Sun soon will start or just has ended, the errors may be much larger. If you want higher accuracy, you must then use the iteration feature. This feature is new as of version 0.7. Here is what I have tried to accomplish with this. a) Compute sunrise or sunset as always, with one exception: to convert LHA from degrees to hours, divide by 15.04107 instead of 15.0 (this accounts for the difference between the solar day and the sidereal day. b) Re-do the computation but compute the Sun's RA and Decl, and also GMST0, for the moment of sunrise or sunset last computed. c) Iterate b) until the computed sunrise or sunset no longer changes significantly. Usually 2 iterations are enough, in rare cases 3 or 4 iterations may be needed. next current previous contains as_list iterator See DateTime::Set. ($sunrise, $sunset) = $sunrise_object->($dt); Internal method. Returns two DateTime objects sunrise and sunset. Please note that the time zone for these objects is set to UTC. So don't forget to set your timezone!! AUTHOR
Ron Hill rkhill@firstlight.net SPECIAL THANKS
Robert Creager [Astro-Sunrise@LogicalChaos.org] for providing help with converting Paul's C code to perl. Flavio S. Glock [fglock@pucrs.br] for providing the the interface to the DateTime::Set module. CREDITS
Paul Schlyer, Stockholm, Sweden for his excellent web page on the subject. Rich Bowen (rbowen@rbowen.com) for suggestions. COPYRIGHT and LICENSE Here is the copyright information provided by Paul Schlyer: Written as DAYLEN.C, 1989-08-16 Modified to SUNRISET.C, 1992-12-01 (c) Paul Schlyter, 1989, 1992 Released to the public domain by Paul Schlyter, December 1992 Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MER- CHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. SEE ALSO
perl(1). DateTime Web page at http://datetime.perl.org/ DateTime::Set documentation DateTime::SpanSet documentation perl v5.8.8 2004-03-31 DateTime::Event::Sunrise(3pm)
All times are GMT -4. The time now is 10:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy