Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Subtract date & time in diferent rows Post 77511 by vanand420 on Sunday 10th of July 2005 05:07:08 AM
Old 07-10-2005
Subtract date & time in diferent rows

Hi Friends Smilie
I have a long file having fields in the form :
Field1 yy/mm/dd hh:mm:ss Duration(Sec)
line 1) 123123 05/11/30 12:12:56 145
line 2) 145235 05/11/30 12:15:15 30
line 3) 145264 05/11/30 13:14:56 178
.
.
I want to subtract yy/dd/dd hh:mm:ss in line (2) from yy/mm/dd hh:mm:ss in line (1) and compare the result(in seconds) with the duration(sec) of line(1).
and echo a message whether it is < or >. I want to apply this to the long file This can be done easily in excel as we usually drag a formula in excel. But in unix how I don't know.
Please Dont refer me to Datecalc as I want specific script to do so.
Thanks In advance.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Time & Date Command

Hey all, When you run the 'ls -la' command it'll show you the time and dates of all files/directories. Now what I am trying to do is create a script that will tell me what files haven't been used in over the past 1 month and what the time and date is that the files that haven't been accessed in... (2 Replies)
Discussion started by: merlin
2 Replies

2. Shell Programming and Scripting

Convert Epoch Time to Standard Date and Time & Vice Versa

Hi guys, I know that this topic has been discuss numerous times, and I have search the net and this forum for it. However, non able to address the problem I faced so far. I am on Solaris Platform and unable to install additional packages like the GNU date and gawk to make use of their... (5 Replies)
Discussion started by: DrivesMeCrazy
5 Replies

3. Shell Programming and Scripting

About date & time difference

Hello All, I was having a look on threads on the Forum about time calculation but didn't find exactly this issue. For instance, if we have these 2 dates, begin & end : 20100430235830 20100501000200 Is there anyway, awk, ksh, perl to calculate the difference in sec and get for... (6 Replies)
Discussion started by: rany1
6 Replies

4. Programming

DATE & TIme

Can we select the datetime from oracle database in “hhmmssnnnccyymmdd” format ? please help to solve this..... (2 Replies)
Discussion started by: Sanal
2 Replies

5. Shell Programming and Scripting

Script to subtract rows HELP

Dear All, Please help with a script which can accomplish the following: Input table: $1 $2 $3 Student1 1 50 Student2 56 75 Student3 77 100 Desired Output: $1 $2 $3 $4 Student1 1 50 Student2 56 75 6 Student3 77 ... (4 Replies)
Discussion started by: saint2006
4 Replies

6. UNIX for Dummies Questions & Answers

Removing duplicate rows & selecting only latest date

Gurus, From a file I need to remove duplicate rows based on the first column data but also we need to consider a date column where we need to keep the latest date (13th column). Ex: Input File: Output File: I know how to take out the duplicates but I couldn't figure out... (5 Replies)
Discussion started by: shash
5 Replies

7. Shell Programming and Scripting

multiple and diferent printf(s) for diferent fields in awk

Hi, I'm trying to print and outrput of a timestamp from a script i did that calcs de time diference betwen 2 timestamps in the format HH:MM:SS and i properly formated it with printf inside awk, but i can't do it with separate statements. This works fine, but can you explaim-me how to do it... (2 Replies)
Discussion started by: grafman
2 Replies

8. Shell Programming and Scripting

Subtract two rows (in Time format)

Hello all, I have written sth like this: #!/bin/bash grep -e XXX -e YYYY myfile.log | grep -v ZZZ | awk '{print $1 " " $2 ";" $3 ";" $9 ";" $11}' > myfile.csv sed -i '1iDate;Time;From;To' myfile.csv => it is clear that it converts log to csv and add a header. Now I want to subtract row... (4 Replies)
Discussion started by: frhling
4 Replies

9. Shell Programming and Scripting

Date command - subtract from given time

the given time is: 12:13:00 how do i subtract a 10 minutes from any given time? date '12:13:00' '-10 min' also tried this: date +12:13:00 '-10 min' (2 Replies)
Discussion started by: SkySmart
2 Replies

10. UNIX for Dummies Questions & Answers

How to chnage format and subtract time and date and get average.?

Hello All , Please support for below request how to change format and subtract time and date and get average. xxx 13-OCT-15 11.32.18.241000 AM 13-OCT-15 11.35.49.089080 AM xxx 13-OCT-15 11.32.24.000000 AM 13-OCT-15 11.45.17.810904 AM xxx 13-OCT-15 11.32.25.232000 AM ... (1 Reply)
Discussion started by: mirwasim
1 Replies
JSON_ENCODE(3)								 1							    JSON_ENCODE(3)

json_encode - Returns the JSON representation of a value

SYNOPSIS
string json_encode (mixed $value, [int $options], [int $depth = 512]) DESCRIPTION
Returns a string containing the JSON representation of $value. PARAMETERS
o $value - The $value being encoded. Can be any type except a resource. All string data must be UTF-8 encoded. Note PHP implements a superset of JSON as specified in the original RFC 4627 - it will also encode and decode scalar types and NULL. RFC 4627 only supports these values when they are nested inside an array or an object. Although this superset is consistent with the expanded definition of "JSON text" in the newer RFC 7159 (which aims to super- sede RFC 4627) and ECMA-404, this may cause interoperability issues with older JSON parsers that adhere strictly to RFC 4627 when encoding a single scalar value. o $options - Bitmask consisting of JSON_HEX_QUOT, JSON_HEX_TAG, JSON_HEX_AMP, JSON_HEX_APOS, JSON_NUMERIC_CHECK, JSON_PRETTY_PRINT, JSON_UNESCAPED_SLASHES, JSON_FORCE_OBJECT, JSON_PRESERVE_ZERO_FRACTION, JSON_UNESCAPED_UNICODE. The behaviour of these constants is described on the JSON constants page. o $depth - Set the maximum depth. Must be greater than zero. RETURN VALUES
Returns a JSON encoded string on success or FALSE on failure. CHANGELOG
+--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 5.6.6 | | | | | | | | | | JSON_PRESERVE_ZERO_FRACTION$option was added. | | | | | 5.5.0 | | | | | | | $depth parameter was added. | | | | | 5.4.0 | | | | | | | | | | JSON_PRETTY_PRINT, JSON_UNESCAPED_SLASHES, and | | | JSON_UNESCAPED_UNICODE$options were added. | | | | | 5.3.3 | | | | | | | | | | JSON_NUMERIC_CHECK$option was added. | | | | | 5.3.0 | | | | | | | The $options parameter was added. | | | | +--------+---------------------------------------------------+ EXAMPLES
Example #1 A json_encode(3) example <?php $arr = array('a' => 1, 'b' => 2, 'c' => 3, 'd' => 4, 'e' => 5); echo json_encode($arr); ?> The above example will output: {"a":1,"b":2,"c":3,"d":4,"e":5} Example #2 A json_encode(3) example showing some options in use <?php $a = array('<foo>',"'bar'",'"baz"','&blong&', "xc3xa9"); echo "Normal: ", json_encode($a), " "; echo "Tags: ", json_encode($a, JSON_HEX_TAG), " "; echo "Apos: ", json_encode($a, JSON_HEX_APOS), " "; echo "Quot: ", json_encode($a, JSON_HEX_QUOT), " "; echo "Amp: ", json_encode($a, JSON_HEX_AMP), " "; echo "Unicode: ", json_encode($a, JSON_UNESCAPED_UNICODE), " "; echo "All: ", json_encode($a, JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_QUOT | JSON_HEX_AMP | JSON_UNESCAPED_UNICODE), " "; $b = array(); echo "Empty array output as array: ", json_encode($b), " "; echo "Empty array output as object: ", json_encode($b, JSON_FORCE_OBJECT), " "; $c = array(array(1,2,3)); echo "Non-associative array output as array: ", json_encode($c), " "; echo "Non-associative array output as object: ", json_encode($c, JSON_FORCE_OBJECT), " "; $d = array('foo' => 'bar', 'baz' => 'long'); echo "Associative array always output as object: ", json_encode($d), " "; echo "Associative array always output as object: ", json_encode($d, JSON_FORCE_OBJECT), " "; ?> The above example will output: Normal: ["<foo>","'bar'",""baz"","&blong&","u00e9"] Tags: ["u003Cfoou003E","'bar'",""baz"","&blong&","u00e9"] Apos: ["<foo>","u0027baru0027",""baz"","&blong&","u00e9"] Quot: ["<foo>","'bar'","u0022bazu0022","&blong&","u00e9"] Amp: ["<foo>","'bar'",""baz"","u0026blongu0026","u00e9"] Unicode: ["<foo>","'bar'",""baz"","&blong&","e"] All: ["u003Cfoou003E","u0027baru0027","u0022bazu0022","u0026blongu0026","e"] Empty array output as array: [] Empty array output as object: {} Non-associative array output as array: [[1,2,3]] Non-associative array output as object: {"0":{"0":1,"1":2,"2":3}} Associative array always output as object: {"foo":"bar","baz":"long"} Associative array always output as object: {"foo":"bar","baz":"long"} Example #3 JSON_NUMERIC_CHECK option example <?php echo "Strings representing numbers automatically turned into numbers".PHP_EOL; $numbers = array('+123123', '-123123', '1.2e3', '0.00001'); var_dump( $numbers, json_encode($numbers, JSON_NUMERIC_CHECK) ); echo "Strings containing improperly formatted numbers".PHP_EOL; $strings = array('+a33123456789', 'a123'); var_dump( $strings, json_encode($strings, JSON_NUMERIC_CHECK) ); ?> The above example will output: Strings representing numbers automatically turned into numbers array(4) { [0]=> string(7) "+123123" [1]=> string(7) "-123123" [2]=> string(5) "1.2e3" [3]=> string(7) "0.00001" } string(28) "[123123,-123123,1200,1.0e-5]" Strings containing improperly formatted numbers array(2) { [0]=> string(13) "+a33123456789" [1]=> string(4) "a123" } string(24) "["+a33123456789","a123"]" Example #4 Sequential versus non-sequential array example <?php echo "Sequential array".PHP_EOL; $sequential = array("foo", "bar", "baz", "blong"); var_dump( $sequential, json_encode($sequential) ); echo PHP_EOL."Non-sequential array".PHP_EOL; $nonsequential = array(1=>"foo", 2=>"bar", 3=>"baz", 4=>"blong"); var_dump( $nonsequential, json_encode($nonsequential) ); echo PHP_EOL."Sequential array with one key unset".PHP_EOL; unset($sequential[1]); var_dump( $sequential, json_encode($sequential) ); ?> The above example will output: Sequential array array(4) { [0]=> string(3) "foo" [1]=> string(3) "bar" [2]=> string(3) "baz" [3]=> string(5) "blong" } string(27) "["foo","bar","baz","blong"]" Non-sequential array array(4) { [1]=> string(3) "foo" [2]=> string(3) "bar" [3]=> string(3) "baz" [4]=> string(5) "blong" } string(43) "{"1":"foo","2":"bar","3":"baz","4":"blong"}" Sequential array with one key unset array(3) { [0]=> string(3) "foo" [2]=> string(3) "baz" [3]=> string(5) "blong" } string(33) "{"0":"foo","2":"baz","3":"blong"}" Example #5 JSON_PRESERVE_ZERO_FRACTION option example <?php var_dump(json_encode(12.0, JSON_PRESERVE_ZERO_FRACTION)); var_dump(json_encode(12.0)); ?> The above example will output: string(4) "12.0" string(2) "12" NOTES
Note In the event of a failure to encode, json_last_error(3) can be used to determine the exact nature of the error. Note When encoding an array, if the keys are not a continuous numeric sequence starting from 0, all keys are encoded as strings, and specified explicitly for each key-value pair. Note Like the reference JSON encoder, json_encode(3) will generate JSON that is a simple value (that is, neither an object nor an array) if given a string, integer, float or boolean as an input $value. While most decoders will accept these values as valid JSON, some may not, as the specification is ambiguous on this point. To summarise, always test that your JSON decoder can handle the output you generate from json_encode(3). SEE ALSO
JsonSerializable, json_decode(3), json_last_error(3), serialize(3). PHP Documentation Group JSON_ENCODE(3)
All times are GMT -4. The time now is 02:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy