need date in awk (Part II)


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting need date in awk (Part II)
# 8  
Old 09-21-2004
Perderabo...I tried your suggestion. I even copied/pasted your syntax. I got the following error message:

awk: syntax error at source line 1
context is
{print09/21/04 >>> 12: <<<
awk: illegal statement at source line 1



-cd
# 9  
Old 09-21-2004
Farzolito:

I tried your suggestion also, copying/pasting your syntax into my script. I received the following error when I ran the script:

awk: syntax error at source line 1
context is
today=09/21/04 >>> 12: <<<
awk: bailing out at source line 1


-cd
# 10  
Old 09-21-2004
One more try...we need a space after that print on any version of awk....

cat $LOG | grep SWI100 | sort | uniq -c | awk '{print '"$today "' "MSP\t" "Rich\t" $3 $12 "\t" $1}'
# 11  
Old 09-21-2004
Perderabo:

Still did not work. I get the following error:

awk: syntax error at source line 1
context is
{print 09/21/04 >>> 14: <<<
awk: illegal statement at source line 1

-cd
# 12  
Old 09-21-2004
How about...

cat $LOG | grep SWI100 | sort | uniq -c | awk '{print '\"$today \"' "MSP\t" "Rich\t" $3 $12 "\t" $1}'
# 13  
Old 09-21-2004
I think it is the space caracter between date and hour in your today's variable which cause error in the awk.

try this perhaps it will be works:

use this variable :
today=`date +'%m/%d/%y_%T'

cat $LOG | grep SWI100 | sort | uniq -c | awk -v today="$today" '{printf today" MSP\t" "Rich\t" $3 $12 "\t" $1}' | sed 's/_/ /g'
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Extract date and time part from filename

Hi, I am facing one scenario in which I need to extract exact position of date and time from the name of the files. For example, Below is the record in which I need to extract position of YYYYMMDD,HHMISS and YYMMDD. Date and time variables can come more than once. I need to use these position... (13 Replies)
Discussion started by: Prathmesh
13 Replies

2. UNIX for Dummies Questions & Answers

Extract Date part from the filename

Hi All, I have incoming source files abcmmyy.txt I need to extract the mmyy part from the filename and pass that to a variable . I really appreciate your quick response on this. Thanks raj (7 Replies)
Discussion started by: rajeevm
7 Replies

3. UNIX for Dummies Questions & Answers

How to get year part from file created date?

Hi Gurus, I need to get year part of file created date. when using ls -l , it only show month, day and time. is there any option I can add to get year portition? Thanks in advance (7 Replies)
Discussion started by: ken6503
7 Replies

4. Shell Programming and Scripting

How do I take out(remove) the date part in the file name in a script?

Hi All, I need to create links between two directories. have multiple files in a specified location. Source Location ex: /opt/xdm/input/ Target Location ex: /opt/xdm input file names: 1. abc_app.aus.apac.yyyymmdd.dtd 2. abcd_app.aus.apac.yyyymmdd.dtd I need to build a code that reads... (1 Reply)
Discussion started by: kthri_82
1 Replies

5. Shell Programming and Scripting

How to remove the date part of the file?

Hi Gurus, I have file name like: abcd.20131005.dat I need to remove mid part of data final name should be abcd.dat thanks in advance (2 Replies)
Discussion started by: ken6503
2 Replies

6. Shell Programming and Scripting

Getting the date part from the log file.

Hi, I have a script that runs to generate a log file which is in this format: Start: Friday, April 29, 2011 18:30 User : Host : Database : I need to write a script that reads this log file (RUN.LOG) and rename the existing log file... (7 Replies)
Discussion started by: ashok@119
7 Replies

7. Shell Programming and Scripting

how to update date part with new increment date time

hi experts, my requirement is like this i need to develop a shell script to update date part with new incremental date time in file some 'X' which is kept at some server location incrementing every two hours.as i am new to this scripting i need support from u people,thanx in advance (1 Reply)
Discussion started by: amanmro
1 Replies

8. Shell Programming and Scripting

Execute a part of shell script only after particular date and time

I have created a simple shell script... say test.sh Contents of test.sh ================ service named restart cp /etc/imp.conf /backup/test/ #-- if date > 15 July 2007 11:23 pm , then only issue the commans below, else exit --- cp /etc/secondimp.conf /backup/test/ rm -f... (2 Replies)
Discussion started by: fed.linuxgossip
2 Replies

9. HP-UX

How do I take out(remove) the date part in the file name?

Hi Guys here I am again, I have two files in a specified location. Location ex: /opt/xdm/input/ input file names: 1. abc_app.yyyymmdd.dtd 2. abd_app.yyyymmdd.dtd I need to build a code that reads the files from the location based on the oldest date and cuts the date part... (5 Replies)
Discussion started by: ruthless
5 Replies

10. Shell Programming and Scripting

Add Date as part of file name

How can I add date in format yyyymmdd to my existing file name ? For example my file name is test.dat then i want it to be test.datyyyymmdd (3 Replies)
Discussion started by: amsh76
3 Replies
Login or Register to Ask a Question