Helpm with time function Post: 302988313

Sponsored Content

Homework and Emergencies Homework & Coursework Questions Helpm with time function Post 302988313 by alula on Friday 23rd of December 2016 10:05:59 AM

12-23-2016

Registered User

Helpm with time function

I want to print the difference (in days) between ($7) and the oldest record date ($6) based on unique ID ($5) on a new field. In addition, I want to subtract oldest date from recent dates(in days) ($6) for each unique ID ($5).

Here is the data looks like

Code:

 7  81  1    47  32070  2010-12-14    20101009  
 7  82  2    10  41920  2010-12-14    20100724  
 7  83  1    67  29446  2010-12-14    20101118   
 7  81  1    47  32070  2011-5-11     20101009     
 7  83  1    67  29446  2011-6-22     20101118     
 7  82  2    10  41920  2011-5-14     20100724

I would like to see as follows

Code:

 7  81  1    47  32070   2010-12-14   20101009     65      147    
 7  82  2    10  41920   2010-12-14   20100724     170     150  
 7  83  1    67  29446   2010-12-14   20101118     26      188  
 7  81  1    47  32070   2011-5-11    20101009      65      147  
 7  83  1    67  29446   2011-6-22    20101118      26      188  
 7  82  2    10  41920   2011-5-14    20100724      170     150

I have used the following code but doesnt work well. could you help me please.

Code:

BEGIN{
  lastid=0
  lastmilk=0
}
{
   milkyear=substr($6,1,4)
  milkmonth=substr($6,5,2)
  milkday=substr($6,7,2)
  
  startmilksec = mktime(""milkyear" "milkmonth" "milkday"  00")
  endmilk = mktime(""milkyear" "milkmonth" "milkday" 00")
   if(lastid!=$5) 
  {
    printf("%s 0 0 0\n", $0) 
  }
  else
  {
    startmilkdiff=startmilk-lastmilk
    printf("%s %0.f %f %f\n", $0, startmilkdiff) # 
  }
   lastid=$5
  lastmilk=startmilk
}

Moderator's Comments:

Please use CODE tags as required by forum rules!

Last edited by RudiC; 12-23-2016 at 12:04 PM.. Reason: Added CODE tags.

alula

View Public Profile for alula

Find all posts by alula

10 More Discussions You Might Find Interesting

1. Programming

C time in milliseconds function.

I need a c function which return the time in: hour min sec and mil sec I am writing on unix os.

2. Programming

find CPU Time for a function (subsecond precision)

Hi, I need to time a certain function in my C/C++ code and I am experiencing some difficulties. I timed it using wallclock time so I know that it takes approximately 500-600 microseconds with gettimeofday(&start, NULL); // my function call gettimeofday(&end, NULL); answer = (end.tv_sec -...

3. Shell Programming and Scripting

time function

Hi, I would like to display the exact time taken to complete running a particular tool or function or program to user I don't know the exact time functions in unix, please help me thanks in advance Example: $test.ksh output should be The...

4. Programming

function time

Hello I have problem with function 'time' to test my program for file copying . How to run the function in my source code ? I try something like that: system("time"); < -- but this don't working

5. Shell Programming and Scripting

Nawk Time Function

Hi All, I am using solaris and nawk. Is there any time function in nawk which is simliar to the shell `date` function ? Can any experts show any examples?

6. Shell Programming and Scripting

Unix function to calcuate the difference in time

HI , I need to get the timedifference between two values... which funcation will help eg: difference betweem 19:22 and 19:43 should give 21 mins

7. UNIX for Dummies Questions & Answers

time function

hello everybody! i want to post a question. So, I use the command 'time a.out' to time the duration of the program a.out. The return value of this function was: real 0m4.116s user 0m4.112s sys 0m0.016s What i want is! I try to find a way to get (NOT manually) the value of real time....

8. Red Hat

lightweight function for measuring time ( better than clock_getime )

HI I have a Red Hat Enterprise with Real Time kernel. Are you aware if there are C functions for this kernel or some code/library for this OS for measuring time more lightweight than clock_gettime and gettimeofday? THe hardware I have is NUMA. Reading forums I found gethrtime but it is...

9. Shell Programming and Scripting

/usr/bin/time Shell Scripting Function

Hello, I have made a Linux Shell Script that downloads 6 files from the Internet and then deletes them. Now i want to use the function "/usr/bin/time" and "bc" to calculate how long the avergate run time for the shell script is. I therefore need to do it 100 times. My shell script code is below: ...

10. OS X (Apple)

'time' does NOT work on a function in 'dash'.

Hi guys and gals... I am writing a piece of code that is dash compliant and came across this error. I have put it in the OSX section as that is what I am using. I have no idea what the 'dash' version is but was installed about 6 months ago. MBP, OSX 10.12.6, default terminal running dash on...

10 More Discussions You Might Find Interesting

1. Programming

C time in milliseconds function.

Discussion started by: kamil

2. Programming

find CPU Time for a function (subsecond precision)

Discussion started by: zynnel

3. Shell Programming and Scripting

time function

Discussion started by: hsekol

4. Programming

function time

Discussion started by: scotty_123

5. Shell Programming and Scripting

Nawk Time Function

Discussion started by: Raynon

6. Shell Programming and Scripting

Unix function to calcuate the difference in time

Discussion started by: savitha

7. UNIX for Dummies Questions & Answers

time function

Discussion started by: nicos

8. Red Hat

lightweight function for measuring time ( better than clock_getime )

Discussion started by: manustone

9. Shell Programming and Scripting

/usr/bin/time Shell Scripting Function

Discussion started by: solo2

10. OS X (Apple)

'time' does NOT work on a function in 'dash'.

Discussion started by: wisecracker