Hello,
I have the following data file which has about 500,000 rows
in $4, I want to keep all the consecutive row matches,
I want to delete the single row entries
Code:
1000
1000
1000
2000 # I want to delete because it does not have a match row
1000
1000
3000
3000
3000
1000 # I want to delete because it does not have a match row
5000
5000
5000
6000 # I want to delete because it does not have a match row
3000
3000
3000
---------------
any help is greatly appreciated.
Thanks,
Charlie
Last edited by Scrutinizer; 05-08-2013 at 12:56 AM..
Reason: code tags
Does anyone know a way to delete rows 6-9 from the below output? I have searched the forum but did not find any thing helpful.
backups01laxint.liuc(s){jsandova}<0>$ nsrjb -v | awk -F' ' '$3>=01{print $0}' | cut -b 1-79 | cat -n
setting verbosity level to `1'
1 slot volume ... (17 Replies)
Hi All,
I am having following file and I want to delete 1 row last column.
Current File Content:
================
procedure test421 put_line
procedure test321 test421
procedure test521 test321
procedure test621 test521
Expected File Content:
===========================
procedure... (3 Replies)
How to delete last row in the file in PERL.
file1 has
a.output
b.output
c.output
d.output
e.output
expected output is
a.output
b.output
c.output
d.output (1 Reply)
hi team,
i have a file txt1 , in that file there r 10 lines . my aim is to cut 2nd and 6th line of the file .
what command we can use for this scenario. (8 Replies)
I want to write a scrpit to merge files row wise (actually concatinating)
main.txt
X Y Z
file 1
A B C
file 2
1 2 3
now i want the script to check if the file1 is empty or not, if empty then make it like
A B C
1 2 3
again to check if second file is empty if not do as done... (0 Replies)
I have a csv file: test1.csv with 26 columns
Sample:
Data collected Comp1,,,,,,,,,,,,,,,,,,,,,,,,,Average
Number of Arrivals with non Zero,0,0,0,0,0,0,0,0,0,...,0
%Utilization,0.1,0.23,0.14,...,0.36
Data collected Comp2,,,,,,,,,,,,,,,,,,,,,,,,,Average
Number of Arrivals with non... (2 Replies)
Hi Friends,
I have a single column data like below.
1
2
3
4
5
I need the output like below.
0
1
2
3
4
where each row (including first row) subtracting from first row and the result should print below like the way shown in output file.
Thanks
Sid (11 Replies)
Hi,
My input file is this way
1.1 0.0 2.4 3.5
7.9 1.8 22.3 4.7 8.9
0.9 1.3 0.0 3.4 5.6
0.0 1.1 2.2 0.0 0.0
1.1 0.0 0.0 3.4 5.6
I would like to delete the entire row, if either of 2nd and 3rd columns are 0.0.
Please note that my values are all decimal values.
So, my output would... (4 Replies)
I have a fixed width file. The records looks something similar to below:
Type ID SSN NAME .....AND SOME MORE FIELDS
A1 1234 .....
A1 1234 .....
B1 1234 .....
M2 4567 .....
M2 4567 .....
N2 4567 .....
N2 4567 .....
A1 9999
N2 9999
Now if A1 is present then B1 has to be present.... (2 Replies)
Hi all,
how can delete duplicate files in file form, e.g.
$cat file1
aaa 123 234 345 456
bbb 345 345 657 568
ccc 345 768 897 456
aaa 123 234 345 456
ddd 786 784 234 263
ccc 345 768 897 456
aaa 123 234 345 456
ccc 345 768 897 456
then i need ouput file1 some, (4 Replies)
Discussion started by: aav1307
4 Replies
LEARN ABOUT PHP
odbc_fetch_row
ODBC_FETCH_ROW(3) 1 ODBC_FETCH_ROW(3)odbc_fetch_row - Fetch a rowSYNOPSIS
bool odbc_fetch_row (resource $result_id, [int $row_number])
DESCRIPTION
Fetches a row of the data that was returned by odbc_do(3) or odbc_exec(3). After odbc_fetch_row(3) is called, the fields of that row can
be accessed with odbc_result(3).
PARAMETERS
o $result_id
- The result identifier.
o $row_number
- If $row_number is not specified, odbc_fetch_row(3) will try to fetch the next row in the result set. Calls to odbc_fetch_row(3)
with and without $row_number can be mixed. To step through the result more than once, you can call odbc_fetch_row(3) with
$row_number 1, and then continue doing odbc_fetch_row(3) without $row_number to review the result. If a driver doesn't support
fetching rows by number, the $row_number parameter is ignored.
RETURN VALUES
Returns TRUE if there was a row, FALSE otherwise.
PHP Documentation Group ODBC_FETCH_ROW(3)