Sponsored Content
Top Forums Shell Programming and Scripting Calculating differences line by line Post 302779321 by SkySmart on Tuesday 12th of March 2013 01:23:52 PM
Old 03-12-2013
the contents of the datafile changed:

Code:
jime=1860,yime=1.23243,lime=[Mar-12-(UTC)]
jime=1859,yime=1.23018,lime=[Mar-12-(UTC)]
jime=1825,yime=1.15371,lime=[Mar-12-(UTC)]
jime=1849,yime=1.20769,lime=[Mar-12-(UTC)]
jime=1841,yime=1.1897,lime=[Mar-12-(UTC)]
jime=1849,yime=1.20769,lime=[Mar-12-(UTC)]

i tried manipulating the fields so the script can adapt to this new datafile layout. "$NF" to work on the second column:

Code:
awk -F= '{prev=$3; print; getline; print $0","($NF-prev)/$NF*100"%"}' datafile

but i keep getting:

Code:
awk: (FILENAME=mile FNR=2) fatal: division by zero attempted

 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

[Solved] Problem in reading a file line by line till it reaches a white line

So, I want to read line-by-line a text file with unknown number of files.... So: a=1 b=1 while ; do b=`sed -n '$ap' test` a=`expr $a + 1` $here do something with b etc done the problem is that sed does not seem to recognise the $a, even when trying sed -n ' $a p' So, I cannot read... (3 Replies)
Discussion started by: hakermania
3 Replies

2. Solaris

Line too long error Replace string with new line line character

I get a file which has all its content in a single row. The file contains xml data containing 3000 records, but all in a single row, making it difficult for Unix to Process the file. I decided to insert a new line character at all occurrences of a particular string in this file (say replacing... (4 Replies)
Discussion started by: ducati
4 Replies

3. Shell Programming and Scripting

How to make diff show differences one line at a time and not group them?

Is there a way to tell diff to show differences one line at a time and not to group them? For example, I have two files: file1: line 1 line 2 line 3 diff line 4 diff line 5 diff line 6 line 7 file2: line 1 line 2 line 3 diff. line 4 diff. line 5 diff. line 6 line 7 (13 Replies)
Discussion started by: mmr11408
13 Replies

4. Shell Programming and Scripting

how to read the contents of two files line by line and compare the line by line?

Hi All, I'm trying to figure out which are the trusted-ips and which are not using a script file.. I have a file named 'ip-list.txt' which contains some ip addresses and another file named 'trusted-ip-list.txt' which also contains some ip addresses. I want to read a line from... (4 Replies)
Discussion started by: mjavalkar
4 Replies

5. Shell Programming and Scripting

Calculating average for every Nth line in the Nth column

Is there an awk script that can easily perform the following operation? I have a data file that is in the format of 1944-12,5.6 1945-01,9.8 1945-02,6.7 1945-03,9.3 1945-04,5.9 1945-05,0.7 1945-06,0.0 1945-07,0.0 1945-08,0.0 1945-09,0.0 1945-10,0.2 1945-11,10.5 1945-12,22.3... (3 Replies)
Discussion started by: ncwxpanther
3 Replies

6. Shell Programming and Scripting

Need a program that read a file line by line and prints out lines 1, 2 & 3 after an empty line...

Hello, I need a program that read a file line by line and prints out lines 1, 2 & 3 after an empty line... An example of entries in the file would be: SRVXPAPI001 ERRO JUN24 07:28:34 1775 REASON= 0000, PROCID= #E506 #1065: TPCIPPR, INDEX= 003F ... (8 Replies)
Discussion started by: Ferocci
8 Replies

7. Shell Programming and Scripting

How to read file line by line and compare subset of 1st line with 2nd?

Hi all, I have a log file say Test.log that gets updated continuously and it has data in pipe separated format. A sample log file would look like: <date1>|<data1>|<url1>|<result1> <date2>|<data2>|<url2>|<result2> <date3>|<data3>|<url3>|<result3> <date4>|<data4>|<url4>|<result4> What I... (3 Replies)
Discussion started by: pat_pramod
3 Replies

8. UNIX for Beginners Questions & Answers

Get an output of lines in pattern 1st line then 10th line then 11th line then 20th line and so on.

Input file: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 (6 Replies)
Discussion started by: Sagar Singh
6 Replies
DateTime::Locale::fil_PH(3)				User Contributed Perl Documentation			       DateTime::Locale::fil_PH(3)

NAME
DateTime::Locale::fil_PH SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'fil_PH' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for Filipino Philippines. DATA
This locale inherits from the DateTime::Locale::fil locale. It contains the following data. Days Wide (format) Lunes Martes Miyerkules Huwebes Biyernes Sabado Linggo Abbreviated (format) Lun Mar Mye Huw Bye Sab Lin Narrow (format) L M M H B S L Wide (stand-alone) Lunes Martes Miyerkules Huwebes Biyernes Sabado Linggo Abbreviated (stand-alone) Lun Mar Mye Huw Bye Sab Lin Narrow (stand-alone) L M M H B S L Months Wide (format) Enero Pebrero Marso Abril Mayo Hunyo Hulyo Agosto Setyembre Oktubre Nobyembre Disyembre Abbreviated (format) Ene Peb Mar Abr May Hun Hul Ago Set Okt Nob Dis Narrow (format) E P M A M H H A S O N D Wide (stand-alone) Enero Pebrero Marso Abril Mayo Hunyo Hulyo Agosto Setyembre Oktubre Nobyembre Disyembre Abbreviated (stand-alone) Ene Peb Mar Abr May Hun Hul Ago Set Okt Nob Dis Narrow (stand-alone) E P M A M H H A S O N D Quarters Wide (format) Q1 Q2 Q3 Q4 Abbreviated (format) Q1 Q2 Q3 Q4 Narrow (format) 1 2 3 4 Wide (stand-alone) Q1 Q2 Q3 Q4 Abbreviated (stand-alone) Q1 Q2 Q3 Q4 Narrow (stand-alone) 1 2 3 4 Eras Wide BCE CE Abbreviated BCE CE Narrow BCE CE Date Formats Full 2008-02-05T18:30:30 = Martes, Pebrero 05 2008 1995-12-22T09:05:02 = Biyernes, Disyembre 22 1995 -0010-09-15T04:44:23 = Sabado, Setyembre 15 -10 Long 2008-02-05T18:30:30 = Pebrero 5, 2008 1995-12-22T09:05:02 = Disyembre 22, 1995 -0010-09-15T04:44:23 = Setyembre 15, -10 Medium 2008-02-05T18:30:30 = Peb 5, 2008 1995-12-22T09:05:02 = Dis 22, 1995 -0010-09-15T04:44:23 = Set 15, -10 Short 2008-02-05T18:30:30 = 2/5/08 1995-12-22T09:05:02 = 12/22/95 -0010-09-15T04:44:23 = 9/15/-10 Default 2008-02-05T18:30:30 = Peb 5, 2008 1995-12-22T09:05:02 = Dis 22, 1995 -0010-09-15T04:44:23 = Set 15, -10 Time Formats Full 2008-02-05T18:30:30 = 18:30:30 UTC 1995-12-22T09:05:02 = 09:05:02 UTC -0010-09-15T04:44:23 = 04:44:23 UTC Long 2008-02-05T18:30:30 = 18:30:30 UTC 1995-12-22T09:05:02 = 09:05:02 UTC -0010-09-15T04:44:23 = 04:44:23 UTC Medium 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 09:05:02 -0010-09-15T04:44:23 = 04:44:23 Short 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 09:05 -0010-09-15T04:44:23 = 04:44 Default 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 09:05:02 -0010-09-15T04:44:23 = 04:44:23 Datetime Formats Full 2008-02-05T18:30:30 = Martes, Pebrero 05 2008 18:30:30 UTC 1995-12-22T09:05:02 = Biyernes, Disyembre 22 1995 09:05:02 UTC -0010-09-15T04:44:23 = Sabado, Setyembre 15 -10 04:44:23 UTC Long 2008-02-05T18:30:30 = Pebrero 5, 2008 18:30:30 UTC 1995-12-22T09:05:02 = Disyembre 22, 1995 09:05:02 UTC -0010-09-15T04:44:23 = Setyembre 15, -10 04:44:23 UTC Medium 2008-02-05T18:30:30 = Peb 5, 2008 18:30:30 1995-12-22T09:05:02 = Dis 22, 1995 09:05:02 -0010-09-15T04:44:23 = Set 15, -10 04:44:23 Short 2008-02-05T18:30:30 = 2/5/08 18:30 1995-12-22T09:05:02 = 12/22/95 09:05 -0010-09-15T04:44:23 = 9/15/-10 04:44 Default 2008-02-05T18:30:30 = Peb 5, 2008 18:30:30 1995-12-22T09:05:02 = Dis 22, 1995 09:05:02 -0010-09-15T04:44:23 = Set 15, -10 04:44:23 Available Formats d (d) 2008-02-05T18:30:30 = 5 1995-12-22T09:05:02 = 22 -0010-09-15T04:44:23 = 15 EEEd (d EEE) 2008-02-05T18:30:30 = 5 Mar 1995-12-22T09:05:02 = 22 Bye -0010-09-15T04:44:23 = 15 Sab Hm (H:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 9:05 -0010-09-15T04:44:23 = 4:44 hm (h:mm a) 2008-02-05T18:30:30 = 6:30 PM 1995-12-22T09:05:02 = 9:05 AM -0010-09-15T04:44:23 = 4:44 AM Hms (H:mm:ss) 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 9:05:02 -0010-09-15T04:44:23 = 4:44:23 hms (h:mm:ss a) 2008-02-05T18:30:30 = 6:30:30 PM 1995-12-22T09:05:02 = 9:05:02 AM -0010-09-15T04:44:23 = 4:44:23 AM M (L) 2008-02-05T18:30:30 = 2 1995-12-22T09:05:02 = 12 -0010-09-15T04:44:23 = 9 Md (M-d) 2008-02-05T18:30:30 = 2-5 1995-12-22T09:05:02 = 12-22 -0010-09-15T04:44:23 = 9-15 MEd (E, M-d) 2008-02-05T18:30:30 = Mar, 2-5 1995-12-22T09:05:02 = Bye, 12-22 -0010-09-15T04:44:23 = Sab, 9-15 MMM (LLL) 2008-02-05T18:30:30 = Peb 1995-12-22T09:05:02 = Dis -0010-09-15T04:44:23 = Set MMMd (MMM d) 2008-02-05T18:30:30 = Peb 5 1995-12-22T09:05:02 = Dis 22 -0010-09-15T04:44:23 = Set 15 MMMEd (E MMM d) 2008-02-05T18:30:30 = Mar Peb 5 1995-12-22T09:05:02 = Bye Dis 22 -0010-09-15T04:44:23 = Sab Set 15 MMMMd (MMMM d) 2008-02-05T18:30:30 = Pebrero 5 1995-12-22T09:05:02 = Disyembre 22 -0010-09-15T04:44:23 = Setyembre 15 MMMMEd (E MMMM d) 2008-02-05T18:30:30 = Mar Pebrero 5 1995-12-22T09:05:02 = Bye Disyembre 22 -0010-09-15T04:44:23 = Sab Setyembre 15 ms (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 y (y) 2008-02-05T18:30:30 = 2008 1995-12-22T09:05:02 = 1995 -0010-09-15T04:44:23 = -10 yM (yyyy-M) 2008-02-05T18:30:30 = 2008-2 1995-12-22T09:05:02 = 1995-12 -0010-09-15T04:44:23 = -010-9 yMEd (EEE, yyyy-M-d) 2008-02-05T18:30:30 = Mar, 2008-2-5 1995-12-22T09:05:02 = Bye, 1995-12-22 -0010-09-15T04:44:23 = Sab, -010-9-15 yMMM (y MMM) 2008-02-05T18:30:30 = 2008 Peb 1995-12-22T09:05:02 = 1995 Dis -0010-09-15T04:44:23 = -10 Set yMMMEd (EEE, y MMM d) 2008-02-05T18:30:30 = Mar, 2008 Peb 5 1995-12-22T09:05:02 = Bye, 1995 Dis 22 -0010-09-15T04:44:23 = Sab, -10 Set 15 yMMMM (y MMMM) 2008-02-05T18:30:30 = 2008 Pebrero 1995-12-22T09:05:02 = 1995 Disyembre -0010-09-15T04:44:23 = -10 Setyembre yQ (y Q) 2008-02-05T18:30:30 = 2008 1 1995-12-22T09:05:02 = 1995 4 -0010-09-15T04:44:23 = -10 3 yQQQ (y QQQ) 2008-02-05T18:30:30 = 2008 Q1 1995-12-22T09:05:02 = 1995 Q4 -0010-09-15T04:44:23 = -10 Q3 yyMM (yy-MM) 2008-02-05T18:30:30 = 08-02 1995-12-22T09:05:02 = 95-12 -0010-09-15T04:44:23 = -10-09 yyMMM (MMM yy) 2008-02-05T18:30:30 = Peb 08 1995-12-22T09:05:02 = Dis 95 -0010-09-15T04:44:23 = Set -10 Miscellaneous Prefers 24 hour time? Yes Local first day of the week Linggo SUPPORT
See DateTime::Locale. AUTHOR
Dave Rolsky <autarch@urth.org> COPYRIGHT
Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's license. perl v5.16.3 2014-06-10 DateTime::Locale::fil_PH(3)
All times are GMT -4. The time now is 01:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy