Hi, experts,
I would like to create a function that can calculate the total number of lines in a saved text file and delete specific lines in that particular file (I only want the last few lines). Hav anybody have the experience and giv me a hand in this? (9 Replies)
Hi all,
I want to remove the files from a folder whcih contain a specific text in it.
eg:
If i have the files like
xxxx.NAME.adadd.ajfaj.kjfha
agsg.NAME.dfshd.djsh.sdjhf
asgd.NAME2.sdhj.djhf.sjdhf
shdd.NAME2.dhse.tywe.eyio
How to remove the files which contain the pattern "NAME"... (3 Replies)
Friends,
I have text file with 700,000 rows.
Once I load this file to our database via our cutom process, it logs the row number for rejected rows.
How do I delete rows from a Large text file based on the Row Number?
Thanks,
Prashant (8 Replies)
I know this is a complicated question but I will try to illustrate it with some data. I have a data file that looks like the following:
1341 NA06985 0 0 2 46.6432798439
1341 NA06991 NA06993 NA06985 2 48.8478948517
1341 NA06993 0 0 1 45.8022601455
1340 NA06994 0 0 1 48.780669145
1340... (1 Reply)
Hi all
I have a file which looks like this
1234|1|Jon|some text|some text
1234|2|Jon|some text|some text
3453|5|Jon|some text|some text
6533|2|Kate|some text|some text
4567|3|Chris|some text|some text
4567|4|Maggie|some text|some text
8764|6|Maggie|some text|some text
My third column is my... (9 Replies)
Dear all,
I would like to delete even lines starting with "N" together with their respective titles which are actually odd lines.
Below is the example of input file. I would like to remove line 8 and 12 together with its title line, i.e., line 7 and 11, respectively.... (2 Replies)
I'm trying to remove a specific number of lines, above and below a specific line of text, highlighted in red:
<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20151205000001
<TRNAMT>10
<FITID>667800001
<CHECKNUM>667800001
<MEMO>BALANCE
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20151207000001... (8 Replies)
Discussion started by: bomsom
8 Replies
LEARN ABOUT PHP
sybase_affected_rows
SYBASE_AFFECTED_ROWS(3)SYBASE_AFFECTED_ROWS(3)sybase_affected_rows - Gets number of affected rows in last querySYNOPSIS
int sybase_affected_rows ([resource $link_identifier])
DESCRIPTION sybase_affected_rows(3) returns the number of rows affected by the last INSERT, UPDATE or DELETE query on the server associated with the
specified link identifier.
This command is not effective for SELECT statements, only on statements which modify records. To retrieve the number of rows returned from
a SELECT, use sybase_num_rows(3).
PARAMETERS
o $link_identifier
- If the link identifier isn't specified, the last opened link is assumed.
RETURN VALUES
Returns the number of affected rows, as an integer.
EXAMPLES
Example #1
Delete-Query
<?php
/* connect to database */
sybase_connect('SYBASE', '', '') or
die("Could not connect");
sybase_select_db("db");
sybase_query("DELETE FROM sometable WHERE id < 10");
printf("Records deleted: %d
", sybase_affected_rows());
?>
The above example will output:
Records deleted: 10
SEE ALSO sybase_num_rows(3).
PHP Documentation Group SYBASE_AFFECTED_ROWS(3)