Sponsored Content
Top Forums Shell Programming and Scripting compare date and time inside data of two files Post 302526680 by ajiwww on Wednesday 1st of June 2011 07:00:53 AM
Old 06-01-2011
CONDITIONS
---------------
values from columns 2 to 5 of a raw of fileA is exactly the same as fileB
if the above condition met, then
6th & 7th columns (date & time) of each raw of fileA is higher than fileB
if both the above conditions met, put the entries of fileB which matches, on a new file fileC
if any of the above conditions are not meeting, then put those unmatching entries of fileA on new file fileD

Note :- each raw of fileA need to be compared with all the raws in fileB


Example :-
------------
take first line of fileA and check for any entries in fileB which matches from column 2 to 5. If matches, then go to next condition
from the matching entries, check that 6th & 7th column value of fileB is higher than fileA
if both above conditions met, save those matching entries on a new file fileD
if any of the above conditions not met, save those unmatching entries of fileA on fileD

hope this helps..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Compare Date And Time

Hi can somebody send me the code for compare two date and run a shell script. following is the code which i actully want but I am getting errors. regard Jamil . /opt/home/rep/.profile #!/bin/sh VALUE=`sqlplus -silent rep/Ndk38f7@dw <<END set pagesize 0 feedback off verify off... (5 Replies)
Discussion started by: Jamil Qadir
5 Replies

2. Shell Programming and Scripting

List Files + data inside files

Hey everyone, I'm trying get a list of files using but also append some data located inside the file. The log files contain two strings that I am trying to extract. These strings are surrounded by tags. Here is a sample log file: ... (2 Replies)
Discussion started by: ToeLint
2 Replies

3. Shell Programming and Scripting

time from 2 files to compare

In first file say first.txt, i have a content say 14:56. In second file, say second.txt i have content say 16:01.... I want to compare if these two times in these 2 files are having a difference of 15 minutes...Can any one please help? (2 Replies)
Discussion started by: manoj.b
2 Replies

4. Shell Programming and Scripting

Split Date/time data to two

Hi all, I have logs(in a log file) with the following structure 20100916011501559;0.812;null;TRUE;;FALSE;0.812;0;0;;19 20100916011504762;0.015;null;TRUE;;FALSE;0;4|4;0.015;;4 20100916011504762;0;null;TRUE;;FALSE;0;0;0;;4 20100916011501731;3.343;null;TRUE;;FALSE;3.156;131|65;0.172;;11... (14 Replies)
Discussion started by: babai
14 Replies

5. Shell Programming and Scripting

ksh compare dates INSIDE a file (ie date A is > date B)

In KSH, I am pasting 2 almost identical files together and each one has a date and time on each line. I need to determine if the first instance of the date/time is greater than the 2nd instance of the date/time. If the first instance is greater, I just need to echo that line. I thought I would... (4 Replies)
Discussion started by: right_coaster
4 Replies

6. Shell Programming and Scripting

need help to compare 2 files inside a loop

Basically, I have a user input a colour into a variable, and then i echo that variable into a text file. Then I need to compare those 2 files which is easy using the diff command. The thing I can not get is how to do this inside of a loop until the variable matches the file. Also if the user enters... (6 Replies)
Discussion started by: cstadnyk1
6 Replies

7. Shell Programming and Scripting

Sorting data file by date and time

Hello. Sorting data file by date and time with the following issues: Date is in the following format m/d/yyyy, no leading zeros Time is in the following format h:m:s AM/PM, no leading zeros Any ideas on how to sort data when the above issues? Could the date/time be converted inline to... (5 Replies)
Discussion started by: JimBurns
5 Replies

8. Shell Programming and Scripting

Need to replace the date inside a node of several rdf files

Hi, I have a rdf zip file. This zip file consists of several *.rdf files. I need to replace the date (this is different for each rdf) inside the node "Date_de_Publication_Periodique" of these rdf files. e.g., awk '/Date_de_Publication_Periodique/ && /XMLSchema#date/' MM_NN-A1B1C1_ABC.rdf ... (11 Replies)
Discussion started by: Ribosome
11 Replies

9. Shell Programming and Scripting

Shell script to compare two files of todays date and yesterday's date

hi all, How to compare two files whether they are same are not...? like i had my input files as 20141201_file.txt and 20141130_file2.txt how to compare the above files based on date .. like todays file and yesterdays file...? (4 Replies)
Discussion started by: hemanthsaikumar
4 Replies

10. UNIX for Beginners Questions & Answers

How to replace a parameter(variable) date value inside a text files daily with current date?

Hello All, we what we call a parameter file (.txt) where my application read dynamic values when the job is triggered, one of such values are below: abc.txt ------------------ line1 line2 line3 $$EDWS_DATE_INSERT=08-27-2019 line4 $$EDWS_PREV_DATE_INSERT=08-26-2019 I am trying to... (1 Reply)
Discussion started by: pradeepp
1 Replies
BIB2BIB(1)						      General Commands Manual							BIB2BIB(1)

NAME
BibX2bib - Filter BibTeX data bases SYNOPSIS
bib2bib [options] <filename> ... DESCRIPTION
bib2bib is a filter tool that reads one or several bibliography files, filters the entries with respect to a given criterion, and outputs the list of selected keys together with a new bibliography file containing only the selected entries. If no input file is given then input is taken from the standard input. Additionally, bib2bib may output a file containing all the keys of entries that satisfy the condition. This second file is suitable for input as option -citefile to bibtex2html OPTIONS
-ob filename specify the filename where the selected entries are output. If not given, it defaults to standard output. -oc filename specify the filename where the list of selected keys is output. If not given, this file is not created. -c condition specify a condition for selecting the entries. The output will retain only the entries that satisfy this condition. If several such condition are given, then only the entries that satisfy all the conditions are selected. The syntax of conditions is described in the complete documentation, notice that it is better to escape shell expansions in that conditions, in other words, you should write conditions between quotes. -expand expand all abbreviations in the output file. Notice that there is no way to ask for expansion of cross-references, since the meaning of such an expansion is unclear: it's better to let bibtex (via bibtex2html) handle the cross-references himself, depending on the style considered. -s field sorts the entries of the bibliography with respect to the given field, which may be $key or $type to refer to the key or to the entry type, as for filter conditions. This options may be used several times to specifiy a lexicographic order, such as by year, then by keys. When the field is $date then entries are sorted chronologically. When sorting, the resulting bibliography will always contain the comments first, then the preambles, then the abbreviations, and finally the regular entries. Be warned that such a sort may put cross-references before entries that refer to them, so be cautious. -r reverses the sort -q , --quiet be quiet. -w , --warn-error stop at the first warning. USAGE WITH BIBTEX2HTML Notice that the two output files are suitable for use with bibtex2html. A typical use would be bib2bib -oc citefile -ob bibfile.bib -c condition file1.bib file2.bib ... bibtex2html -citefile citefile bibfile.bib which will produce exactly the HTML file for the selected references. Notice finally that bibtex2html will expand the strings (by default, unless you specify the -noexpand option) but not the cross-references. AUTHOR
Bib2bib has been written by Jean-Christophe Filliatre and Claude Marche. This manpage has been compiled by Ralf Treinen from the original bib2bib documentation. SEE ALSO
bibtex2html(1),bibtex(1),hevea(1) http://www.lri.fr/~filliatr/bibtex2html/ For complete documentation, please check the bibtex2html manual. On a Debian system the manual can be found at /usr/share/doc/bibtex2html both in the formats postscript and HTML, or via the Debian help system. BIB2BIB(1)
All times are GMT -4. The time now is 02:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy