The perl code seems to work but not the awk.
Can you help ? I am using solaris by the way.
Also, can you explain your perl code so that i can understand better. What is the function of "-ane"
Code:
$ nawk '!x[$1]++' file
x[$1]++': Event not found
$ awk '!x[$1]++' file
x[$1]++': Event not found
$ /usr/xpg4/bin/awk '!x[$1]++' file
x[$1]++': Event not found
Hi,
I want to print column value based on row number say multiple of 8.
Input file:
line 1 67 34
line 2 45 57
. . .
. . .
line 8 12 46
. . .
. . .
line 16 24 90
. . .
. . .
line 24 49 67
Output
46
90
67 (2 Replies)
Hi, Please read the whole thread.
I have been working on this script below. It works fine, feel free to copy and test with the INPUT File below as well.
example:
PACKET DATA PROTOCOL CONTEXT DATA
APNID PDPADD EQOSID VPAA PDPCH PDPTY PDPID
10 ... (6 Replies)
Hi all
I have file with columns
F3 pathway CPS
F2
H2
H4
H5
H6 no pathway CMP
H7
H8
H9
H10
My expected output is
F3 pathway CPS
F2 pathway CPS (10 Replies)
I have a table with this structure:
cola colb colc
1 19 lemon
20 31 lemon
32 100 lemon
159 205 cherries
210 500 cherries
and need to parse it into this format:
cola colb colc
1 100 lemon
159 500 cherries
So I need the first row of cola and the last row of colb if colc has the... (3 Replies)
Hi,
I have a comma separated file. I would like to print every alternate columns into a new row.
Example input file:
Name : John, Age : 30, DOB : 30-Oct-2018
Example output:
Name,Age,DOB
John,30,30-Oct-2018 (3 Replies)
Hello,
I have this table:
chr1_16857_17742 - chr1 17369 17436 "ENST00000619216.1"; "MIR6859-1"; - 67
chr1_16857_17742 - chr1 14404 29570 "ENST00000488147.1"; "WASH7P"; - 885
chr1_16857_18061 - chr1 ... (5 Replies)
Discussion started by: coppuca
5 Replies
LEARN ABOUT PHP
msql_fetch_row
MSQL_FETCH_ROW(3)MSQL_FETCH_ROW(3)msql_fetch_row - Get row as enumerated arraySYNOPSIS
array msql_fetch_row (resource $result)
DESCRIPTION msql_fetch_row(3) fetches one row of data from the result associated with the specified query identifier. The row is returned as an array.
Each result column is stored in an array offset, starting at offset 0.
Subsequent call to msql_fetch_row(3) would return the next row in the result set, or FALSE if there are no more rows.
PARAMETERS
o $
result -The result resource that is being evaluated. This result comes from a call to msql_query(3).
RETURN VALUES
Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.
EXAMPLES
Example #1
msql_fetch_row(3) example
<?php
$con = msql_connect();
if (!$con) {
die('Server connection problem: ' . msql_error());
}
if (!msql_select_db('test', $con)) {
die('Database connection problem: ' . msql_error());
}
$result = msql_query('SELECT id, name FROM people', $con);
if (!$result) {
die('Query execution problem: ' . msql_error());
}
while ($row = msql_fetch_row($result)) {
echo $row[0] . ': ' . $row[1] . "
";
}
msql_free_result($result);
?>
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.0.4 | |
| | |
| | A bug was fixed when retrieving data from col- |
| | umns containing NULL values. Such columns were |
| | not placed into the resulting array. |
| | |
+--------+---------------------------------------------------+
SEE ALSO msql_fetch_array(3), msql_fetch_object(3), msql_data_seek(3), msql_result(3).
PHP Documentation Group MSQL_FETCH_ROW(3)