Search Results

its not giving any error, but giving wrong data. all the converted date is showing a value "1315962000"

output
------
0 ebs-sql1-b EBSCClaimStore Memphis_Prod_SQL_Diff...

its not recognizing the comma parameter that is been specified in the command
awk '{print $1,$2,$3,$4,$5; system("date +%s -d $6,$7")}'

here is the output
0 ebs-sql1-b xxxxxxxxxxxxx...

The 6th & 7th column of the text files represents date & time. I need this to be converted in julian format using command "date +%s -d <date>". I know the command, but dont know how to use it on the...

thanks for the script, its partially successful :b:

its not checking columns 2 - 5 of fileA is exactly same as in fileB :wall:
date and time wise checking is perfect

---------- Post updated at...

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...

i need to compare the 6th & 7th (date & time) column of each raw of fileA with fileB. If the values are higher, then paste the output on new file fileC and of not, paste it on fileD

i have two files with identical no of columns. 6th columns is date (MM/DD/YY format) and 7th columns is time (HH:MM:SS) format. I need to compare these two vaules and if the date & time is higher...

i tried test1.sh and test3.sh and both are not working, its keep on looping and not creating any fileC and dumping lots of data to fileD. :wall:

Pls try on below files

CONDITIONS

values from...

files are not so large. date wise, yes you are correct. i need to split and then compare. But once i have a base script, then can modify that date part later. Any idea why the syntax error is coming ?

I was able to do it in another way

cat fileA | while read CLIENT DB POLICY SCHEDULE DATE TIME
do
if ( grep -w "$DB" fileB | grep -w "$CLIENT" | grep -w "$POLICY" | grep -w "$SCHEDULE" )
...

I have two files; file A and file B. I need all the entries of file A to be compared with file B line by line. If the entry exists on file B, then save those on file C; if no then save it on file D
...

thank you so much man, so kind if yo...:b:

thank you so much, working like a dream.
Can you pls explain how exactly its working

File
6 dbnawldb010-b office Memphis_Corp_SQL_Diff Memphis-Corp-SQL-Inc-Application-Backup 03/09/11 03:24:04
42 luigi-b IPNRemitDB Memphis_Corp_SQL_Diff Memphis-Corp-SQL-Inc-Application-Backup...

yea its working, thanks

---------- Post updated at 10:10 AM ---------- Previous update was at 10:06 AM ----------

another concern.
If i added some more lines on the same file

6...

no output

# awk -F"[ :]" '$6~"03/08/11"&&$7>=6' file
#

Please use code tags (https://www.unix.com/misc.php?do=bbcode&#code) when posting data and code samples!

I have a text file which got 6th coloumn as date and 7th coloumn as time. The text contains data for last one week. I need to remove all the data whose date & time is after 03/08/2011 06:00:00 and...

ok, thanks its working fine now

OK, that "special date" was just for testing.:p

What the problem here is, its only sorting the value as per the first "-k". If we try to use multiple times with different sort values, its not...

i was able to find out the code
# sort -k 6.8,6.9 -k 6.5,6.6 -k 6.1,6.2 -k 7.8,7.9 -k 7.5,7.6 -k 7.1,7.2 test1

6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup...

# cat test
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 09/30/11 11:80:82
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 05/22/11...

Thanks for the code, its working on the file. But the another file with same format, its not working
# cat test1
6 dbclstr-b Logs Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup...

Hello All,

Need a shell script to sort entries in a file by date and time. Below are the entries in the file, i need to sort it first by the date and then time

Note :- Date is in MM/DD/YY...