06-16-2011
The awk code does not really work, because I want to delete the whole row that contains the specific string, not just that particular string and column.
10 More Discussions You Might Find Interesting
1. Programming
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)
Discussion started by: dniz
9 Replies
2. Shell Programming and Scripting
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)
Discussion started by: sparks
3 Replies
3. Shell Programming and Scripting
Hello
i want to know a way so i can delete all the strings in file from the begning till a specific string (1 Reply)
Discussion started by: modcan
1 Replies
4. Shell Programming and Scripting
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)
Discussion started by: ppat7046
8 Replies
5. Shell Programming and Scripting
Hi
I do have a text file with 1000's of lines with 1 row and column with a specific pattern.
1102
1
1
1
1
1234
1
1
1
1
1009
1
1
1
1
1056
1 (3 Replies)
Discussion started by: Lucky Ali
3 Replies
6. UNIX for Dummies Questions & Answers
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)
Discussion started by: evelibertine
1 Replies
7. UNIX for Dummies Questions & Answers
How do I go about deleting specific rows from a text file (given row number)? (5 Replies)
Discussion started by: evelibertine
5 Replies
8. UNIX for Dummies Questions & Answers
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)
Discussion started by: A-V
9 Replies
9. Shell Programming and Scripting
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)
Discussion started by: huiyee1
2 Replies
10. Shell Programming and Scripting
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
msql_result
MSQL_RESULT(3) MSQL_RESULT(3)
msql_result - Get result data
SYNOPSIS
string msql_result (resource $result, int $row, [mixed $field])
DESCRIPTION
msql_result(3) returns the contents of one cell from a mSQL result set.
When working on large result sets, you should consider using one of the functions that fetch an entire row (specified below). As these
functions return the contents of multiple cells in one function call, they are often much quicker than msql_result(3).
Recommended high-performance alternatives: msql_fetch_row(3), msql_fetch_array(3), and msql_fetch_object(3).
PARAMETERS
o $
result -The result resource that is being evaluated. This result comes from a call to msql_query(3).
o $row
- The row offset.
o $field
- Can be the field's offset, or the field's name, or the field's table dot field's name (tablename.fieldname.). If the column name
has been aliased ('select foo as bar from ...'), use the alias instead of the column name.
Note
Specifying a numeric field offset is much quicker than specifying a fieldname or tablename.fieldname.
RETURN VALUES
Returns the contents of the cell at the row and offset in the specified mSQL result set.
PHP Documentation Group MSQL_RESULT(3)