Get days using awk


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Get days using awk
# 1  
Old 12-11-2019
Get days using awk

hi
i want to get days using awk command
[source data]
Code:
kkk bb 20191210 ccc ddd
kkk bb 20191211 ccc ddd

[output data]
Code:
kkk bb 20191210 Tue ccc ddd
kkk bb 20191211 Wed ccc ddd

please help me

--- Post updated at 06:19 AM ---

in addition,
i want to get the day of the week using the third column value.of source data

Moderator's Comments:
Mod Comment Please do wrap your samples/codes in CODE TAGS as per forum rules.
# 2  
Old 12-11-2019
Hello tomato00,

On UNIX.com we encourage users to add their efforts whatever they have put in order to solve their own problems.
So kindly do let us know your efforts.

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
# 3  
Old 12-11-2019
i tried do follow, but i can't print => aaa 20191212 Thu
Code:
#>echo "aaa 20191212" | awk '{system("echo $(date -d "$2" +'%a')") }'
Thu


Last edited by RavinderSingh13; 12-11-2019 at 03:08 AM..
# 4  
Old 12-11-2019
Hello tomato00,

Could you please try following.

Code:
cat script.ksh
declare -a arr=("test" "Monday" "Tuesday" "Wednesday" "Thurday" "Friday" "Saturday" "Sunday")

while read first second date_part rest_part
do
   echo "$first $second $date_part ${arr[$(date -d "$date_part" +%u)]} $rest_part"
done < "Input_file"

Thanks,
R. Singh

Last edited by RavinderSingh13; 12-11-2019 at 05:02 AM..
These 2 Users Gave Thanks to RavinderSingh13 For This Post:
# 5  
Old 12-11-2019
hi RavinderSingh13
wonderful, my problem solved.
Thank you so much.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. HP-UX

awk command in hp UNIX subtract 30 days automatically from current date without date illegal option

current date command runs well awk -v t="$(date +%Y-%m-%d)" -F "'" '$1 < t' myname.dat subtract 30 days fails awk -v t="$(date --date="-30days" +%Y-%m-%d)" -F "'" '$1 < t' myname.dat awk command in hp unix subtract 30 days automatically from current date without date illegal option error... (20 Replies)
Discussion started by: kmarcus
20 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. Red Hat

VM becomes slow every 3-4 days

Hi, I have RHEL 6.1 on VM, where Big data is installed. Every 3-4 days, its web interface become very slow and I had to reboot this VM. I was checking with "top" and that shows that free memory is less. Can this be a reason for slowness ? No big load on CPU. # free -m total ... (6 Replies)
Discussion started by: solaris_1977
6 Replies

4. Shell Programming and Scripting

Get the no of hours between days

Hi, i have a date 1- 2013101511 date2 -2013101812 need toget the no of hours between them,can any one tellme the logic. (6 Replies)
Discussion started by: sandeep karna
6 Replies

5. Shell Programming and Scripting

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... (2 Replies)
Discussion started by: twinion
2 Replies

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

7. Shell Programming and Scripting

before x days

hello, I needed to put value of date - 20 days in certain variable like this: before20d=`TZ=MET+480 date +%Y%m%d` echo $before20d value just perfect ...what I need and if I execute "date": Wed Nov 10 11:58:43 MET 2010 on the other solaris platform if I execute this I get... (4 Replies)
Discussion started by: abdulaziz
4 Replies

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

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