Sponsored Content
Full Discussion: date in awk
Top Forums UNIX for Dummies Questions & Answers date in awk Post 302130428 by matrixmadhan on Monday 6th of August 2007 06:46:07 AM
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
 

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. 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
COLLATOR_ASORT(3)							 1							 COLLATOR_ASORT(3)

Collator::asort - Sort array maintaining index association

       Object oriented style

SYNOPSIS
public bool Collator::asort (array &$arr, [int $sort_flag]) DESCRIPTION
Procedural style bool collator_asort (Collator $coll, array &$arr, [int $sort_flag]) This function sorts an array such that array indices maintain their correlation with the array elements they are associated with. This is used mainly when sorting associative arrays where the actual element order is significant. Array elements will have sort order according to current locale rules. Equivalent to standard PHP asort(3). PARAMETERS
o $coll -Collator object. o $arr -Array of strings to sort. o $sort_flag - Optional sorting type, one of the following: o Collator::SORT_REGULAR - compare items normally (don't change types) o Collator::SORT_NUMERIC - compare items numerically o Collator::SORT_STRING - compare items as strings Default $sort_flag value is Collator::SORT_REGULAR. It is also used if an invalid $sort_flag value has been specified. RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 collator_asort(3)example <?php $coll = collator_create( 'en_US' ); $arr = array( 'a' => '100', 'b' => '50', 'c' => '7' ); collator_asort( $coll, $arr, Collator::SORT_NUMERIC ); var_export( $arr ); collator_asort( $coll, $arr, Collator::SORT_STRING ); var_export( $arr ); ?> The above example will output: array ( 'c' => '7', 'b' => '50', 'a' => '100', )array ( 'a' => '100', 'b' => '50', 'c' => '7', ) SEE ALSO
Collator constants, collator_sort(3), collator_sort_with_sort_keys(3). PHP Documentation Group COLLATOR_ASORT(3)
All times are GMT -4. The time now is 07:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy