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
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT PHP
pg_fetch_array
PG_FETCH_ARRAY(3) PG_FETCH_ARRAY(3)
pg_fetch_array - Fetch a row as an array
SYNOPSIS
array pg_fetch_array (resource $result, [int $row], [int $result_type = PGSQL_BOTH])
DESCRIPTION
pg_fetch_array(3) returns an array that corresponds to the fetched row (record).
pg_fetch_array(3) is an extended version of pg_fetch_row(3). In addition to storing the data in the numeric indices (field number) to the
result array, it can also store the data using associative indices (field name). It stores both indicies by default.
Note
This function sets NULL fields to the PHP NULL value.
pg_fetch_array(3) is NOT significantly slower than using pg_fetch_row(3), and is significantly easier to use.
PARAMETERS
o $result
- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).
o $row
- Row number in result to fetch. Rows are numbered from 0 upwards. If omitted or NULL, the next row is fetched.
o $result_type
- An optional parameter that controls how the returned array is indexed. $result_type is a constant and can take the following
values: PGSQL_ASSOC, PGSQL_NUM and PGSQL_BOTH. Using PGSQL_NUM, pg_fetch_array(3) will return an array with numerical indices,
using PGSQL_ASSOC it will return only associative indices while PGSQL_BOTH, the default, will return both numerical and associa-
tive indices.
RETURN VALUES
An array indexed numerically (beginning with 0) or associatively (indexed by field name), or both. Each value in the array is represented
as a string. Database NULL values are returned as NULL.
FALSE is returned if $row exceeds the number of rows in the set, there are no more rows, or on any other error.
EXAMPLES
Example #1
pg_fetch_array(3) example
<?php
$conn = pg_pconnect("dbname=publisher");
if (!$conn) {
echo "An error occurred.
";
exit;
}
$result = pg_query($conn, "SELECT author, email FROM authors");
if (!$result) {
echo "An error occurred.
";
exit;
}
$arr = pg_fetch_array($result, 0, PGSQL_NUM);
echo $arr[0] . " <- Row 1 Author
";
echo $arr[1] . " <- Row 1 E-mail
";
// As of PHP 4.1.0, the row parameter is optional; NULL can be passed instead,
// to pass a result_type. Successive calls to pg_fetch_array will return the
// next row.
$arr = pg_fetch_array($result, NULL, PGSQL_ASSOC);
echo $arr["author"] . " <- Row 2 Author
";
echo $arr["email"] . " <- Row 2 E-mail
";
$arr = pg_fetch_array($result);
echo $arr["author"] . " <- Row 3 Author
";
echo $arr[1] . " <- Row 3 E-mail
";
?>
SEE ALSO
pg_fetch_row(3), pg_fetch_object(3), pg_fetch_result(3).
PHP Documentation Group PG_FETCH_ARRAY(3)