Get days using awk


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Get days using awk
# 1  
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  
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  
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 04:08 AM..
# 4  
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 06:02 AM..
These 2 Users Gave Thanks to RavinderSingh13 For This Post:
# 5  
hi RavinderSingh13
wonderful, my problem solved.
Thank you so much.
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #414
Difficulty: Easy
JavaScript is a high-level, interpreted scripting language that conforms to the ECMAScript specification.
True or False?

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

Last command for two days

Dear Expert, I'm using RED Hat Linux AS 5, Can you please help me to view the last 2 days logins to server using "last" command. Thank you, Fareed. (5 Replies)
Discussion started by: Mohammed Faiz
5 Replies

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

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

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

7. UNIX for Dummies Questions & Answers

3 days old date

can anyone please suggest me how do I get 3 days old date using korn shell in aix environment. FILEDT1=`date +%Y-%m-%d` FILEDT=$((FILEDT1 -3)) echo $FILEDT 1994 however my expected result is: 2009-08-01 Thanks Mark (4 Replies)
Discussion started by: pavan_test
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

Featured Tech Videos