Deleting row if all column values are a particular string
Hello,
I have a very large file for which I would like to remove all rows for which the value of columns 2-5 is zero.
For instance I would like this file:
To become this file:
I'm aware that you can use 'Awk' to remove rows for which a particular column has a specific value, but I can't seem to figure out how to remove a row if multiple columns have to have a particular value (i.e zero).
Thanks!
Moderator's Comments:
Please use code tags when posting data and code samples!
Last edited by vgersh99; 10-19-2012 at 01:18 PM..
Reason: code tags, please!
Hi All,
I needd to convert values in a row to a column.
eg: Input is as: value1,value2,value3,value4,.........,value N
Required Output:
Value1
Value2
Value3
.
.
.
Value N
Please help.... (3 Replies)
How can you delete a row if a certain column is bigger than a certain number?
I have the following input:
20080709 20081222 95750 1 0 0.02 94.88
20080709 20081222 95750 2 0 0.89 94.88
20080709 20081222 9575 1 0 0 94.88
20080709 20081222 9575 2 0 0 94.88
20080709 20081222 9587.5 1 0 0... (1 Reply)
How can you delete a row if a certain column is bigger than a certain number?
I have the following input:
20080709 20081222 95750 1 0 0.02 94.88
20080709 20081222 95750 2 0 0.89 94.88
20080709 20081222 9575 1 0 0 94.88
20080709 20081222 9575 2 0 0 94.88
20080709 20081222 9587.5 1 0 0... (6 Replies)
HI,
I need to arrange values of a colum in row.
e.g.
input file :
Alpha<>123
AAAA<>6754
Beta<>456
BBBB<>63784
CCC<>783
Gama<>789
Alpha<>555
AAAA<>6754
BBBB<>63784
Beta<>666
CCC<>783
Gama<>888 (9 Replies)
Hi,
I have a file which consists of two columns but the first one can be varying in length like
123456789 0abcd
123456789 0abcd
4015 0 0abcd
5000 0abcd
I want to go through the file reading each line, count the number of characters in the first column and delete... (2 Replies)
Hi ,
I have been trying to write a awk script which will have the following Output
1. Append the last Characters of the lines matching pattern xxxxxxxxx & then a space & then Append the last Characters of the lines matching pattern yyyyyyyyy
2. the process will continue till end of file &... (10 Replies)
Dear Folks
Hello
I have a column of numbers, say:
26
79
68
I want to add one to each row value and get this desire column:
26
27
79
80
68
69 (6 Replies)
Discussion started by: sajmar
6 Replies
LEARN ABOUT PHP
ifx_fetch_row
IFX_FETCH_ROW(3) 1 IFX_FETCH_ROW(3)ifx_fetch_row - Get row as an associative arraySYNOPSIS
array ifx_fetch_row (resource $result_id, [mixed $position])
DESCRIPTION
Fetches one row of data from the result associated with the specified result identifier.
Subsequent calls to ifx_fetch_row(3) would return the next row in the result set, or FALSE if there are no more rows.
PARAMETERS
o $result_id
-$result_id is a valid resultid returned by ifx_query(3) or ifx_prepare(3) (select type queries only!).
o $position
- An optional parameter for a "fetch" operation on "scroll" cursors: NEXT, PREVIOUS, CURRENT, FIRST, LAST or a number. If you
specify a number, an "absolute" row fetch is executed. This parameter is optional, and only valid for SCROLL cursors.
RETURN VALUES
Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows.
Blob columns are returned as integer blob id values for use in ifx_get_blob(3) unless you have used ifx_textasvarchar(1) or ifx_byteasvar-
char(1), in which case blobs are returned as string values.
EXAMPLES
Example #1
Informix fetch rows
<?php
$rid = ifx_prepare ("select * from emp where name like " . $name,
$connid, IFX_SCROLL);
if (! $rid) {
/* ... error ... */
}
$rowcount = ifx_affected_rows($rid);
if ($rowcount > 1000) {
printf ("Too many rows in result set (%d)
<br />", $rowcount);
die ("Please restrict your query<br />
");
}
if (! ifx_do ($rid)) {
/* ... error ... */
}
$row = ifx_fetch_row ($rid, "NEXT");
while (is_array($row)) {
for (reset($row); $fieldname=key($row); next($row)) {
$fieldvalue = $row[$fieldname];
printf ("%s = %s,", $fieldname, $fieldvalue);
}
printf("
<br />");
$row = ifx_fetch_row($rid, "NEXT");
}
ifx_free_result ($rid);
?>
PHP Documentation Group IFX_FETCH_ROW(3)