Working out days of the week and processing file in 3 working days


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Working out days of the week and processing file in 3 working days
# 1  
Old 05-29-2013
Working out days of the week and processing file in 3 working days

Hi guys i need advice on the approach to this one......

I have a file say called
Thisfile.20130524.txt
i need to work out from the date 20130524 what day of the week that was and then process the file in 3 working days. (so not counting saturday or sunday....(will not worry about bank holidays at the moment)

so in this example the 24th was a friday ignore the 25th and 26th being saturday and sunday so i would process the file on the 29th.


so breaking it down

1. Need to work out from the file name the day of the week
2. Take the day of the week and count 3 days forward not including the weekends

Can someone suggest how i would approach this? Maybe using the Cal and nawk? Any suggestions would be helpful. I do believe my brain has shutdown and gone on holiday Smilie
# 2  
Old 05-29-2013
Quote:
Originally Posted by twinion
1. Need to work out from the file name the day of the week
2. Take the day of the week and count 3 days forward not including the weekends
Code:
#! /bin/bash

f="Thisfile.20130521.txt"

dt=`echo $f | cut -d'.' -f2`
day=`date -d $dt +%a`

if [[ "$day" == "Wed" || "$day" == "Thu" || "$day" == "Fri" ]]
then
    fut_dt=$(( $dt + 5 ))
else
    fut_dt=$(( $dt + 3 ))
fi

date -d "$fut_dt" +"%Y-%m-%d %a"

This User Gave Thanks to balajesuri For This Post:
# 3  
Old 05-29-2013
I see what your doing here and that looks like a very easy approach thanks! Thats what i love about unix, i was trying something far far more long winded, so i love your spin on it!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Linux froze and got back working 5 days later, no reboot.

Hello my friends, I've come across the weirdest of glitches. I'm running a simple weather monitor (just temperature) on a Raspbeery Pi 3B (Raspbian Linux 4.14.98-v7+). It has a 3G modem that sends out simple packets to my server at home. On june 5th I lost remote access to the device.... (1 Reply)
Discussion started by: OmahaWiz
1 Replies

2. UNIX for Beginners Questions & Answers

How to find a file that's modified more than 2 days ago but less than 5 days ago?

How to find a file that's modified more than 2 days ago but was modified less than 5 days ago by use of any Linux utility ? (4 Replies)
Discussion started by: abdulbadii
4 Replies

3. How to Post in the The UNIX and Linux Forums

Get all business days from week including today

I am trying to get last 5 business day . trying for d in Mon Tue Wed Thu Fri do date +%Y%m%d -d "last $d" done gives me date Thu Oct 20 23:56:26 EDT 2016 20161017 20161018 20161019 20161013 20161014 expected output should be 20161017 20161018 20161019 20161020 (1 Reply)
Discussion started by: abhii
1 Replies

4. Shell Programming and Scripting

KSH script Not working (calculate days since 1/1/2000 given day 4444)

I am unable to get this KSH script to work. Can someone help. I've been told this should work with KSH93. Which I think I have on Solaris 10. If I do a grep -i version /usr/dt/bin/dtksh I get @(#)Version M-12/28/93d @(#)Version 12/28/93 @(#)Version M-12/28/93 This is correct for... (5 Replies)
Discussion started by: thibodc
5 Replies

5. Shell Programming and Scripting

Cron job running for some days and is not running for some days

Hi.. i have written a shell script and made this script to run on every day night 11: 55 pm using a cron job. This cron job running for some days and is not running for some day. but i need this script to run every day night. Please help me. Here is the cron tab entries, 55 23 * * *... (1 Reply)
Discussion started by: vidhyaS
1 Replies

6. Shell Programming and Scripting

Delete a file after 3 days

Hi.. Am using diff to compare 2 directories(A & B) and as ouput i get a list of files which are found only in directory B ( I used grep & sed to create the list). Now I want to delete the files which are found only in dir B after 3 days. Please help me with this. Thanks CoolAtt (7 Replies)
Discussion started by: coolatt
7 Replies

7. Shell Programming and Scripting

date for two days or 3 days ago

i need a script that can tell me the date 2 days ago or 3 days ago. please help (7 Replies)
Discussion started by: tomjones
7 Replies

8. Shell Programming and Scripting

How many days since a file was modified?

I am trying to write a script to backup my laptop to a NAS drive using rsync. I want the backup to be done, only if it has been more than a week since my last backup. Each time the rsync command executes, I also create a file backuptime.txt file, with the time at which the script completed the... (1 Reply)
Discussion started by: anandjayaraman
1 Replies

9. Shell Programming and Scripting

number of working days

Hi There, Can you help me writing an unix script which tells me number of working days between two dates. say d1 and d2. The answer should be Integer. is it possible in Unix. cheers, (1 Reply)
Discussion started by: rahulkav
1 Replies

10. Shell Programming and Scripting

ls latest 4 days or specify days of files in the directory

Hi, I would like to list latest 2 days, 3 days or 4 days,etc of files in the directory... how? is it using ls? (3 Replies)
Discussion started by: happyv
3 Replies
Login or Register to Ask a Question