Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

date -d 'May 20, 2010' +%d%m in awk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting date -d 'May 20, 2010' +%d%m in awk
# 1  
Old 08-17-2010
date -d 'May 20, 2010' +%d%m in awk
Hi,

I am working on Redhat GNU linux

Code:
#!/usr/bin/ksh
awk '
{
        dial_date="May 26, 2010"
        print dial_date
        aa ='`date -d '"dial_date"' +%d%m%Y`'
        print aa
} END {}' < "input"

Error output:
Code:
date: invalid date `"dial_date"'
awk: cmd. line:5:       aa =
awk: cmd. line:5:           ^ unexpected newline or end of string

The variable dial_date will have a value like "May 26, 2010". I need the output as dd/mm/yyyy. This logic should run within an awk loop. I am not able to represent the variable 'dial_date' inside the date syntax correctly. Please help.
Last edited by Scott; 08-17-2010 at 12:30 PM.. Reason: Please use code tags
# 2  
Old 08-17-2010
Code:
"date -d "dial_date " +%d%m%Y" | getline aa

# 3  
Old 08-17-2010
I tried :
`"date -d "dial_date " +%d%m%Y"` | getline aa
I got an error : sh -c
# 4  
Old 08-17-2010
Dont add backticks. Just replace your code by mine and run it
# 5  
Old 08-18-2010
#!/usr/bin/ksh
awk '
{
dial_date="May 26, 2010"
print dial_date
"date -d "dial_date " +%d%m%Y" | getline aa
print aa
} END {}' < "input"
exit 0


Messge
/tenant1> test.ksh
May 26, 2010
sh: +%d%m%Y: command not found
May 26, 2010
Login or Register to Ask a Question

Previous Thread | Next Thread

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

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

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

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

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

7. Shell Programming and Scripting

gregorian date with awk

Hi everybody: I'm trying to create files database, and to do this I'd like to create them with this format: date hour julian-day SZA other-values from the original file I've this format: - , year, julian-day, minute, other-values 112,2004,84,2300,-3.352,,,,,,,,,,, To do this I'd... (0 Replies)
Discussion started by: tonet
0 Replies

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