Hi
I have a file having 1000 rows. Now I would like to remove 10 rows from it. Plz give me the script.
Eg:
input file like
4 1 4500.0 1
5 1 1.0 30
6 1 1.0 4500
7 1 4.0 730
7 2 500000.0 730
8 1 785460.0 45
8 7 94255.0 30
9 1 31800.0 30
9 4 36000.0 30
10 1 15000.0 30... (5 Replies)
I need to delete rows based on the number of lines in a different file, I have a piece of code with me working but when I merge with my C application, it doesnt work.
sed '1,'\"`wc -l < /tmp/fileyyyy`\"'d' /tmp/fileA > /tmp/filexxxx
Can anyone give me an alternate solution for the above (2 Replies)
Hi Dude,
I am struck up with another problem,Pls help me
I am new to perl , I have little knowledge only.
The scenario is
ssenthil = rw
anilkg = rw
@group1 = rw
anilkg = rw
ssenthil = rw
i need output as below , I want to find "anilkg" and delete the preceding... (12 Replies)
each individual (row) has genotype expressed for each SNP (column)
file1.txt
1 1 A G A T G T A A A A A A A A A A A A A A A A A A A A A
2 2 G A A A A A A A A A A A A A A A A A A A A A A A A A A
3 3 A A A A A A A A A A A A A A A A A A A A A A A A A A A
4 4 G A G T A T A A A A A A A A A A A... (3 Replies)
Hi I have one file which is containing about 5000 rows and 20 columns
I will just explain about my requirement here briefly with sample file, I have attached also, please help....me..
1 28.25 36.42
5 28.26 36.42
10 28.23 36.43
15 28.22 36.43
20 28.2 36.42
25... (6 Replies)
I have an Output file which has the result
YYYY 95,77
YYYY
YYYY 95
YYYY 95
YYYY 95
YYYY 95
YYYY 95
YYYY 95
YYYY 95
YYYY 95
YYYY
YYYY
YYYY
YYYY
I would like to display the above along with a single line with above info. Final output should be
YYYY 95 (3 Replies)
I have the file sed1.txt and I need to strip the brackets (]) and content inside them only when
I have two or three letters followed by a colon.
for example,it may be any letter, not just abc
]
]
#-- cat sed1.txt
1 ] FISICA
2 ]PORTUGUES
3 ] ]MATEMATICA
4 ]]INGLES ]
5 ]QUIMICA
6... (2 Replies)
Hi All ,
I am having a file like this
INPUT FILE
###############################
addfd_mjlala kksks sksks ks
annsns_bbox_2 (sksksk ksks )
adnndn_nsns_bbox_3 (( jsjsdj sjsj )
malm_dkdm lsls lsl
mdndk_mkmd_dkd_bbox_4_kdkd
ksksk skksk_bbox_jsj_KSK ((jsjsj jsjsj )... (2 Replies)
PDO.EXEC(3) 1 PDO.EXEC(3)PDO ::exec - Execute an SQL statement and return the number of affected rows
SYNOPSIS
public int PDO::exec (string $statement)
DESCRIPTION PDO.exec(3) executes an SQL statement in a single function call, returning the number of rows affected by the statement.
PDO.exec(3) does not return results from a SELECT statement. For a SELECT statement that you only need to issue once during your program,
consider issuing PDO.query(3). For a statement that you need to issue multiple times, prepare a PDOStatement object with PDO.prepare(3) and
issue the statement with PDOStatement.execute(3).
PARAMETERS
o $statement
- The SQL statement to prepare and execute. Data inside the query should be properly escaped.
RETURN VALUES PDO.exec(3) returns the number of rows that were modified or deleted by the SQL statement you issued. If no rows were affected, PDO.exec(3)
returns 0.
Warning
This function may return Boolean FALSE, but may also return a non-Boolean value which evaluates to FALSE. Please read the section on
Booleans for more information. Use the === operator for testing the return value of this function.
The following example incorrectly relies on the return value of PDO.exec(3), wherein a statement that affected 0 rows results in a call to
die(3):
<?php
$db->exec() or die(print_r($db->errorInfo(), true));
?>
EXAMPLES
Example #1
Issuing a DELETE statement
Count the number of rows deleted by a DELETE statement with no WHERE clause.
<?php
$dbh = new PDO('odbc:sample', 'db2inst1', 'ibmdb2');
/* Delete all rows from the FRUIT table */
$count = $dbh->exec("DELETE FROM fruit WHERE colour = 'red'");
/* Return number of rows that were deleted */
print("Deleted $count rows.
");
?>
The above example will output:
Deleted 1 rows.
SEE ALSO PDO.prepare(3), PDO.query(3), PDOStatement.execute(3).
PHP Documentation Group PDO.EXEC(3)