[SOLVED] Date Calculations using script!!

anishkumarv · 09-23-2011, 06:24 PM

Hi all,

Thanks in Advance , i am very new to programming part in script i think using some caluations+ sed command only we can do this process in script.

for example:

i have file in that one line is like this

Quote:

between '2011-08-01' and '2011-12-01'

using sed i can replace the date and all but my requirement is

The script runs every friday , suppose if i run this on 10th month means.

the script need to change the value in the file like this

Quote:

between '2011-09-01' and '2012-01-01'

every time the month alone need to change in this format

Quote:

between 'current month -1month' and 'current month + 3 months'

Ideas welcome to solve this script

claudelepoisson · 09-23-2011, 08:31 PM

sed -i "$line c between '$(date --date="- 1 month" +%Y-%m)-01' and '$(date --date="+ 3 months" +%Y-%m)-01'" $filename

where $line is the line number.
c is the sed command to replace the line with the following text.
date has handy time difference calculation and output format options.
If the line number might change, you will want to use regular expressions to find the right line.
Please ask where you need more explainations.

Yours,

anishkumarv · 09-23-2011, 09:35 PM

Hi ,

It works, but it entirely replace the other content in the line ,

This is the content of the file: this all content comes in a single line

Quote:

select b.id as cli_id,b.login as cli_login, b.pname as cli_name, b.cname as cli_company, b.phone as cli_phone, b.email as cli_email, (select (value / 1048576) from Limits where limit_name='disk_space' and id=b.limits_id) as Client_Package, b.cr_date, (select FROM_UNIXTIME(value,"%Y-%m-%d") from Limits where limit_name='expiration' and id=b.limits_id) as Client_expire, If(b.status=0,'Active','Inactive') as Cli_Status, a.name as dom_name, If(a.status=0,'Active','Inactive') as Dom_Package, a.cr_date as dom_create, (select FROM_UNIXTIME(value,"%Y-%m-%d") from Limits where limit_name='expiration' and id=a.limits_id) as dom_expire, (select (value / 1048576) from Limits where limit_name='disk_space' and id=a.limits_id) as Dom_Package, round((a.real_size / 1048576)) as Dom_usage from domains a, clients b where (select FROM_UNIXTIME(value,"%Y-%m-%d") from Limits where limit_name='expiration' and id=a.limits_id and (FROM_UNIXTIME(value,"%Y-%m-%d") between '2011-08-01' and '2011-12-01') ) and a.cl_id=b.id group by a.id;

Quote:

between '2011-08-01' and '2011-12-01'

in that i need to replace the date part alone.

if i used your command means it entirely replace the other content in a line and display "between '2011-08-01' and '2011-12-01'" only this content

i think in sed there is option to change the particuar word in a line, i will check thanks for your help dude you made my day.

grail · 09-24-2011, 03:59 AM

So assuming you have not missed out more of the file that will impact the script, simply use the advised change and search for the word 'between' as it only appears once.

anishkumarv · 09-24-2011, 12:24 PM

Hi all,

Code:

sed -i "/between  '2011-08-01' and '2011-12-01'/'between '$(date --date="- 1 month" +%Y-%m)-01' and '$(date --date="+ 3 months" +%Y-%m)-01'/g" /var/tmp/p.sql

i used this command to search and replace in that file but still no luck :-(

grail · 09-24-2011, 12:46 PM

well there probably should be some escaping around the place but it works fine for me:

Code:

sed "s/between[^)]*/between '$(date --date="- 1 month" +%Y-%m)-01' and '$(date --date="+ 3 months" +%Y-%m)-01'/" /var/tmp/p.sql

TB0ne · 09-24-2011, 02:04 PM

Quote:

Originally Posted by grail

well there probably should be some escaping around the place but it works fine for me:

Code:

sed "s/between[^)]*/between '$(date --date="- 1 month" +%Y-%m)-01' and '$(date --date="+ 3 months" +%Y-%m)-01'/" /var/tmp/p.sql

grail, you are much more patient than I am. You've written so many of his scripts, you should be getting a paycheck by now.

The pattern seems to keep repeating itself:
http://www.linuxquestions.org/questi...e-line-901450/
http://www.linuxquestions.org/questi...g-bash-902673/
http://www.linuxquestions.org/questi...ng-awk-896800/
http://www.linuxquestions.org/questi...script-896608/
http://www.linuxquestions.org/questi...ectory-894137/

anishkumarv · 09-24-2011, 02:25 PM

Quote:

Originally Posted by TB0ne

grail, you are much more patient than I am. You've written so many of his scripts, you should be getting a paycheck by now.

The pattern seems to keep repeating itself:
http://www.linuxquestions.org/questi...e-line-901450/
http://www.linuxquestions.org/questi...g-bash-902673/
http://www.linuxquestions.org/questi...ng-awk-896800/
http://www.linuxquestions.org/questi...script-896608/
http://www.linuxquestions.org/questi...ectory-894137/

hmm i felt bad

hmmm @ Grail Thanks man

TB0ne · 09-24-2011, 03:12 PM

Quote:

Originally Posted by anishkumarv

hmm i felt bad

Really?? From another of your posts:

Quote:

Originally Posted by aniskumarv

i dont feel ashame never ever!! i know my values and goals, as a senior member i didnt expect from you, words are most harmful than bullets..hmmm days are not to far to become master in linux domain,

Again, I really hope you do advance...but until you start applying what you've been told, learning on your own, and stop asking to be spoon-fed answers, you won't. Instead of posting over and over "I get this error when I ran the command..what do I do??", try experimenting with it, on your own. Figure out your own answers.

After over a year here, you're not a 'newbie' anymore...you should be able to figure out how to write a simple script, use sed and awk, and make things work

anishkumarv · 09-24-2011, 03:36 PM

hmmm sure i will, i can.