need date in awk


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting need date in awk
# 1  
Old 09-15-2004
need date in awk

Hello all:

Running SunOS 5.6 on a SPARCstation-5...and using bourne shell.
This is a line from a script I am writing:

LOG=/opt/msplib/sys/logs/alarm.log$*

grep "Call Answered" $LOG |wc -l | awk '{ print "Call Answered\t" $1 "\tIVR\t" "AR-a"}



It works great, and produces the following output:

Call Answered 1468 IVR AR-a


My problem is that I need to insert a timestamp between "1468" and "IVR", preferably in the following format: 9/11/04 12:00 AM

I have tried to incorporate the "date" command into my awk statement, but have been unsuccessful.

I am not very familiar with awk, and did not see anything in man awk that jumped out at me.

Any suggestions??

-cd
# 2  
Old 09-15-2004
Set up a variable and then use it in the awk command

today=`date +'%m/%d/%y %T'`
/usr/xpg4/bin/awk -v today=$today '{print $1 "$today"}'

(Not sure my syntax and date format are correct...see this post for more info on awk )
# 3  
Old 09-15-2004
RTM:

I already tried that approach...no luck. Any other ideas, anyone??

-cd
# 4  
Old 09-15-2004
/usr/xpg4/bin/awk -v today="$today" '{print $1 today}'

would print the first field immediately followed by the date.
# 5  
Old 09-15-2004
That did it, Perderabo. Thanks alot!!!

-cd
# 6  
Old 02-17-2006
Bug I like this format.

Referencing the last (below) I have included:

ERRORLOG=/appl/finance/findev/ar/bin/arlog.NWS

I want to grep: grep "NEW TIME STAMP AT" $ERRORLOG

and include any data generated after date. How can I include any lines generated after date of last transmission?



Quote:
Originally Posted by cdunavent
Hello all:

Running SunOS 5.6 on a SPARCstation-5...and using bourne shell.
This is a line from a script I am writing:

LOG=/opt/msplib/sys/logs/alarm.log$*

grep "Call Answered" $LOG |wc -l | awk '{ print "Call Answered\t" $1 "\tIVR\t" "AR-a"}



It works great, and produces the following output:

Call Answered 1468 IVR AR-a


My problem is that I need to insert a timestamp between "1468" and "IVR", preferably in the following format: 9/11/04 12:00 AM

I have tried to incorporate the "date" command into my awk statement, but have been unsuccessful.

I am not very familiar with awk, and did not see anything in man awk that jumped out at me.

Any suggestions??

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

3. Shell Programming and Scripting

Find week of the year for given date using date command inside awk

Hi all, Need an urgent help on the below scenario. script: awk -F"," 'BEGIN { #some variable assignment} { #some calculation and put values in array} END { year=#getting it from array and assume this will be 2014 month=#getting it from array and this will be 05 date=#... (7 Replies)
Discussion started by: vijaidhas
7 Replies

4. Shell Programming and Scripting

Passing date into awk...

Hi All.... I need to pass date into awk and parse logfile based on that.... i used both awk and /usr/xpg4/bin/awk... both are throwing up error..... So here is the stuff... when i use /usr/xpg4/bin/awk : DATE=`date '+%Y %b %d'` START=00 END=23 /usr/xpg4/bin/awk -v DATE={"$DATE"} -v... (3 Replies)
Discussion started by: Nithz
3 Replies

5. UNIX for Dummies Questions & Answers

awk, splitting date

can any1 explain me hw is below wrking: wat is substr and dd,mmyear used for wat values will go in dese? sdt='31122010235959' sdate=`validate_date $sdt` validate_date() { dt="$1" set `echo $dt | nawk '{ print... (2 Replies)
Discussion started by: musu
2 Replies

6. UNIX for Dummies Questions & Answers

Adding date when using awk

Hi, I want to print the number of lines of a file along with filename and today's date. Ex: XXX|07-22-2010|8 I am using as wc -c -l file.txt | awk '{print "XXX|",date +"%m-%d-%Y","|",$1}' But this one prints as AAA| 0 | 8 Can anyone please help me on this for printing the date? ... (3 Replies)
Discussion started by: aeroticman
3 Replies

7. Shell Programming and Scripting

using awk to print date

i want to use awk to print the first,second and add date as third column in a file awk -F"|" ' { print $1,$2,current date }' tom.unl >> top.txt how can i achieve this,i need the comma's to seperate them and finally print current date and time as the third. i want output like... (5 Replies)
Discussion started by: tomjones
5 Replies

8. UNIX for Dummies Questions & Answers

awk for date

Hello All, in my script i want to get the month part of date. I need the month part because i will grep logs every month using it. When i run the "date" command i got the below result: serverprod{root}>date Mon Aug 24 14:01:20 EEST 2009 but when i type the below command i got Aug24... (5 Replies)
Discussion started by: EAGL€
5 Replies

9. UNIX for Dummies Questions & Answers

Use of system date in awk

i'm facing problems in using system date in a awk script... it should display the date in a report in mm/dd/yy format.. please help me in this case.. thanks (3 Replies)
Discussion started by: Manish4
3 Replies

10. UNIX for Dummies Questions & Answers

date in awk

Hi, Can anyone tell me how can we assign a system date to a variable in awk script? Also how can we use this varible to print this in an other file. Regards, Jamuna (13 Replies)
Discussion started by: jam_prasanna
13 Replies
Login or Register to Ask a Question