Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Date comparison script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Date comparison script
# 1  
Old 11-27-2012
Date comparison script
hi,

I have a file named user.cfg under /var/member/

Code:
 
#user.cfg file under /var/member/
login user: root #how are you
login pass: admin #where are you
M: user1 pass1 #20121008
M: user2 pass2 #20111230
M: user3 pass3 #20091220
M: user4 pass4 #20070210
M: user5 pass5 #20130708
M: user6 pass6 #20141008
M: user7 pass7 #20101008
.
.
.
.
M: user90 pass90 #20121222
M: user91 pass91 #20121227
M: user92 pass92 #20131102
M: user93 pass93 #20120809

What I would like to do is to have a script to read user.cfg file, it will search each line only starting with "M:" and find # sign in each line, then will check expired dates.
If the date is expired, the script shall remove related lines and will save by overwriting the existing user.cfg file.

So the output of user.cfg should be :

Code:
 
#user.cfg file under /var/member/
login user: root #how are you
login pass: admin #where are you
M: user5 pass1 #20130708
M: user6 pass1 #20141008
.
.
.
.
M: user90 pass90 #20121222
M: user91 pass91 #20121227
M: user92 pass92 #20131102

I have read some other threads about date comparison but none of them exactly the same with my user.cfg file.

Thanks in advance
Baris35
# 2  
Old 11-27-2012
Code:
 
$ nawk -F\# -v d=$(date +%Y%m%d) '!/^M/{print;next}{if($NF>d)print}' /var/member/user.cfg
#user.cfg file under /var/member/
login user: root #how are you
login pass: admin #where are you
M: user5 pass5 #20130708
M: user6 pass6 #20141008
.
.
.
.
M: user90 pass90 #20121222
M: user91 pass91 #20121227
M: user92 pass92 #20131102

This User Gave Thanks to itkamaraj For This Post:
baris35
# 3  
Old 11-27-2012
Its the same question here:
https://www.unix.com/shell-programmin...lp-script.html

And as I write, if its CCcam, do NOT remove the line, it only fills the log, change cards to 0 by use F: user pass 0 0 0 { 0:0:0 }
# 4  
Old 11-27-2012
Quote:
Originally Posted by Jotne
Its the same question here:


And as I write, if its CCcam, do NOT remove the line, it only fills the log, change cards to 0 by use F: user pass 0 0 0 { 0:0:0 }
Thanks for your reply Jotne,
I was not knowing what was Ccccam until I saw your reply. The strange is thing that our samples have resemblance. Unable to manage complicated things shown in your thread and itkamaraj's answer is enough for me.
Problem has been solved by means of your valuable help.
The thread would be locked/closed if it is possible.

Thanks million times again&again.
Baris35
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk IF date comparison help

Hey everyone, I'm trying to create a script using awk and if that will list all of our aws tapes that have archived date that is past 90 days from todays current date, so that I can pass that to my aws command to remove. The fifth column is the creation date in epoch/seconds, so I'm... (13 Replies)
Discussion started by: beyondmondays
13 Replies

2. UNIX for Dummies Questions & Answers

Date comparison

I have below txt file 02.05.2014 10.05.2014 17.09.2014 My requirement is the user enter date field should compare the input file if user enter date as 12.03.2013 it should compare with all date one by one from input file 12.03.2013 -ne 02.05.2014 12.03.2013 -ne 10.05.2014... (3 Replies)
Discussion started by: stew
3 Replies

3. Shell Programming and Scripting

Date Comparison

Hi Need some function or step to compare the date as given below. Example: Date_1: 25/04/2013 Date_2: 20/07/2012 if Date_1 is greater than Date_2 then do... else do.. fi Need exact unix steps to compare the above condition Use code tags please, see PM. (5 Replies)
Discussion started by: anshaa
5 Replies

4. Shell Programming and Scripting

Date and Time comparison using shell script

Hi, I'm having two fields in the file F1|F2 20111220|102000 F1 ->YYYYMMDD F2 ->HHMMSS Now, I need to compare this with current date & time and need to return the difference value in hours. Already, I checked with datecalc from the forum. So, need hints from Shell Gurus. Thanks (10 Replies)
Discussion started by: buzzusa
10 Replies

5. UNIX for Dummies Questions & Answers

date comparison

Hi friends, I would like to compare two dates in an IF statement. This is what I am trying, but it doesn't work. date=20120122 minus=6 if ; then ... fi what would the IF clause looks like? Thanks! :) (5 Replies)
Discussion started by: kokoro
5 Replies

6. Solaris

Date comparison

Date comparison Hello all I am writing a scrip that will take action so long as the date with in the file is older than 3 months. The file will contain multiple rows of data. Each row will probably start with the date. My question... What is the exact code that should be used for date... (1 Reply)
Discussion started by: UofU
1 Replies

7. Homework & Coursework Questions

Date comparison with 'string date having slashes and time zone' in Bash only

1. The problem statement, all variables and given/known data: I have standard web server log file. It contains different columns (like IP address, request result code, request type etc) including a date column with the format . I have developed a log analysis command line utility that displays... (1 Reply)
Discussion started by: TariqYousaf
1 Replies

8. Shell Programming and Scripting

date comparison in bash

Hi I have this simple script: #!/bin/bash date1=2009:07:15:12:36 date2=2009:07:15:12:16 echo $date1 echo $date2 datediff= #datediff=date1-date2 echo datediff is$datediff How do i return the difference in seconds? (6 Replies)
Discussion started by: carp.dk
6 Replies

9. Shell Programming and Scripting

Date comparison

Hi all, I've a shell script which runs on Bourne shell. I've to do a date comparison. If the value of the supplied parameter(in format YYYYMMDD)is greater than todays's date(format YYYYMMDD), it should prompt the user that the supplied date is greater than today's date. The script is given... (6 Replies)
Discussion started by: sumesh.abraham
6 Replies

10. Shell Programming and Scripting

date comparison

How can I compare two dates in String format (eg. May 23 2006 05:30:21) in AWK? Thanks (2 Replies)
Discussion started by: dkr123
2 Replies
Login or Register to Ask a Question