date in awk


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers date in awk
# 1  
Old 08-06-2007
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
# 2  
Old 08-06-2007
Code:
v=`date`
echo 1 | awk -v var=$v '{ print var }'

# 3  
Old 08-06-2007
one more without using intermediate variables
Smilie
Code:
awk 'BEGIN{ "date" | getline; print }'

# 4  
Old 08-06-2007
I have a file two files
rrp1
{optimal@Simha}110:cat rrp1
VALUE|DATE|USER|
123|||
243|||
432|||

rrp2
VALUE|USER|
243|RRP|

below scipt writes the user id in rrp2 to rrp1 corrsponding to value field
#!/bin/sh
BEGIN{
FS="|";
while(getline<ARGV[1]>0)
arr[$1]=$2;
delete ARGV[1];
}
{
#print arr[$1];
key=$1;
if(key in arr)
print $1 FS rr FS arr[key] FS;
else
print $0;
}
can any one tell how can i modify this script to write system date into the date field of rrp1
# 5  
Old 08-06-2007
try this,

Code:
awk -F"|" 'BEGIN{ "date" | getline dateVal; OFS="|"; while( getline < "2") { arr[$1]=$2 } }{ for (i in arr) { if ($1 == i) { $2=dateVal; $3=arr[i]} } print }' 1

output Smilie

Code:
VALUE|DATE|USER|
123|||
243|Mon Aug  6 15:33:11 IST 2007|RRP|
432|||

# 6  
Old 08-06-2007
matrix,

i need the date to be in %d-%b-%Y format. Also can you paste your executable script? cos when i tried i am not getting the output
# 7  
Old 08-06-2007
Quote:
Originally Posted by jam_prasanna
matrix,

i need the date to be in %d-%b-%Y format. Also can you paste your executable script? cos when i tried i am not getting the output
Just change the format as required,

Code:
awk -F"|" 'BEGIN{ "date +%d-%b-%Y" | getline dateVal; OFS="|"; while( getline < "2") { arr[$1]=$2 } }{ for (i in arr) { if ($1 == i) { $2=dateVal; $3=arr[i]} } print }' 1

Code:
VALUE|DATE|USER|
123|||
243|06-Aug-2007|RRP|
432|||

Do you get any errors ?

Just run this awk command, you should be getting it
 
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. Shell Programming and Scripting

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... (5 Replies)
Discussion started by: cdunavent
5 Replies
Login or Register to Ask a Question