Hi,
I need a shell script which should find the latest date in the field of file and print that line only. For eg.,
I have a file /date.log
Name Date Status
IBM 06/06/07 close
DELL 07/27/07 open
DELL 06/07/07 open
: : :
From... (1 Reply)
Ok here's what I'm trying to do. I need to get a listing of all the mountpoints on a system into a file, which is easy enough, just using something like "mount | awk '{print $1}'"
However, on a couple of systems, they have some mount points looking like this:
/stage
/stand
/usr
/MFPIS... (2 Replies)
Hi,
I need to delete all occurences of the repeated lines from a file and retain only the lines that is not repeated elsewhere in the file. As seen below the first two lines are same except that for the string "From BaseLine" and "From SMS".I shouldn't consider the string "From SMS" and "From... (7 Replies)
I'm trying to remove lines of data that contain duplicate data in a specific column.
For example.
apple 12345
apple 54321
apple 14234
orange 55656
orange 88989
orange 99898
I only want to see
apple 12345
orange 55656
How would i go about doing this? (5 Replies)
Hi,
I have a directory which contains a number of sub directories. They are named as 1.0.0, 1.0.1, 1.0.2...1.1.0..1.1.1...1.2.0..and so on..
Basically these are the tags created at the time of release. Tags are named as major.minor.buildnumber format for modules.
Now I have to search the... (2 Replies)
Hi,
How to identify duplicate columns in a row?
Input data: may have 30 columns
9211480750 LK 120070417 920091030
9211480893 AZ 120070607
9205323621 O7 120090914 120090914 1420090914 2020090914 2020090914
9211479568 AZ 120070327 320090730
9211479571 MM 120070326
9211480892 MM 120070324... (3 Replies)
Gurus,
From a file I need to remove duplicate rows based on the first column data but also we need to consider a date column where we need to keep the latest date (13th column).
Ex:
Input File:
Output File:
I know how to take out the duplicates but I couldn't figure out... (5 Replies)
Hi all
I have a big file like this in rows and columns from 2 column onwards the next column is desciption of previous column means 3rd columns is description of 2 columns and 5 column is description of 4 column.
All cloumns are separated by comma
... (1 Reply)
I have tried the following code and with that i couldnt achieve what i want.
#!/usr/bin/bash
find ./ -type f \( -iname "*.xml" \) | sort -n > fileList
sed -i '/\.\/fileList/d' fileList
NAMEOFTHISFILE=$(echo $0|sed -e 's/\/()$*.^|/\\&/g')
sed -i "/$NAMEOFTHISFILE/d"... (2 Replies)
Discussion started by: gold2k8
2 Replies
LEARN ABOUT PHP
pg_fetch_result
PG_FETCH_RESULT(3)PG_FETCH_RESULT(3)pg_fetch_result - Returns values from a result resourceSYNOPSIS
string pg_fetch_result (resource $result, int $row, mixed $field)
DESCRIPTION
string pg_fetch_result (resource $result, mixed $field)
pg_fetch_result(3) returns the value of a particular row and field (column) in a PostgreSQL result resource.
Note
This function used to be called pg_result(3).
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, next row is fetched.
o $field
- A string representing the name of the field (column) to fetch, otherwise an int representing the field number to fetch. Fields
are numbered from 0 upwards.
RETURN VALUES
Boolean is returned as "t" or "f". All other types, including arrays are returned as strings formatted in the same default PostgreSQL man-
ner that you would see in the psql program. Database NULL values are returned as NULL.
FALSE is returned if $row exceeds the number of rows in the set, or on any other error.
EXAMPLES
Example #1
pg_fetch_result(3) example
<?php
$db = pg_connect("dbname=users user=me") || die();
$res = pg_query($db, "SELECT 1 UNION ALL SELECT 2");
$val = pg_fetch_result($res, 1, 0);
echo "First field in the second row is: ", $val, "
";
?>
The above example will output:
First field in the second row is: 2
SEE ALSO pg_query(3), pg_fetch_array(3).
PHP Documentation Group PG_FETCH_RESULT(3)