I have a file that will sometimes contain a pattern. The pattern is this:
W/D FRM CHK 00
I want to find any lines with this pattern, delete those lines, and also delete the line above and the line below. (1 Reply)
I have a file that will sometimes contain a pattern. The pattern is this:
FRM CHK 0000
I want to find any lines with this pattern, delete those lines, and also delete the line above and the line below. (4 Replies)
This is my first post, please be nice. I have tried to google and read different tutorials.
The task at hand is:
Input file input.txt (example)
abc123defhij-E-1234jslo
456ujs-W-abXjklp
From this file the task is to grep the -E- and -W- strings that are unique and write a new file... (5 Replies)
Hi all,
I am trying to extract the values ( text between the xml tags) based on the Order Number.
here is the sample input
<?xml version="1.0" encoding="UTF-8"?>
<NJCustomer>
<Header>
<MessageIdentifier>Y504173382</MessageIdentifier>
... (13 Replies)
Hi,
I have got the below requirement. please suggest.
I have a file like,
Processing Item is:
/data/ing/cfg2/abc.txt
/data/ing/cfg3/bgc.txt
Processing Item is:
/data/cmd/for2/ght.txt
/data/kernal/config.klgt.txt
I want to process the above file to get the output file like,
... (5 Replies)
Hi,
I have file in my $datadir as below :-
SAT_1.txt
SAT_2.txt
BAT_UD.lst
BAT_DD1.lst
DUTT_1.txt
DUTT_la.txt
Expected result :-
should get all the above file in $<Filename>_file.lst
Below is my code :-
for i in SAT BAT DUTT
do
touch a.lst
cd $datadir (1 Reply)
Hi there, I am pretty new to those things, so I couldn't figure out how to solve this, and if it is actually that easy. just found that awk could help:(.
so i have a textfile with strings and numbers (originally copy pasted from word, therefore some empty cells) in the following structure:
SC... (9 Replies)
The intended result should be :
PDF converters
'empty line'
gpdftext and pdftotext?xml version="1.0"?>
xml:space="preserve"><note-content version="0.1" xmlns:/tomboy/link" xmlns:size="http://beatniksoftware.com/tomboy/size">PDF converters
gpdftext and pdftotext</note-content>... (9 Replies)
I am trying to combine lines with these conditions:
1. First line starts with text of "libname VALUE db2 datasrc" where VALUE can be any text.
2. If condition1 is met then continue to combine lines through a line that ends with a semicolon.
3. Ignore case when matching patterns and remove any... (5 Replies)
Hi All,
i want to write a shell script read below file line by line and want to exclude the lines which contains empty value for MOUNTPOINT field.
i am using centos 7 Operating system.
want to read below file.
# cat /tmp/d5
NAME="/dev/sda" TYPE="disk" SIZE="60G" OWNER="root"... (4 Replies)
Discussion started by: balu1234
4 Replies
LEARN ABOUT PHP
maxdb_info
MAXDB_INFO(3) 1 MAXDB_INFO(3)maxdb_info - Retrieves information about the most recently executed query
Procedural style
SYNOPSIS
string maxdb_info (resource $link)
DESCRIPTION
Object oriented style
string$maxdb->info ()
The maxdb_info(3) function returns a string providing information about the last query executed. The nature of this string is provided
below:
Possible maxdb_info return values
+---------------------------------------+----------------------------------------------+
| Query type | |
| | |
| | Example result string |
| | |
+---------------------------------------+----------------------------------------------+
| INSERT INTO...SELECT... | |
| | |
| | Records: 100 Duplicates: 0 Warnings: 0 |
| | |
|INSERT INTO...VALUES (...),(...),(...) | |
| | |
| | Records: 3 Duplicates: 0 Warnings: 0 |
| | |
| LOAD DATA INFILE ... | |
| | |
| | Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 |
| | |
| ALTER TABLE ... | |
| | |
| | Records: 3 Duplicates: 0 Warnings: 0 |
| | |
| UPDATE ... | |
| | |
| | Rows matched: 40 Changed: 40 Warnings: 0 |
| | |
+---------------------------------------+----------------------------------------------+
Note
Queries which do not fall into one of the above formats are not supported. In these situations, maxdb_info(3) will return an empty
string.
RETURN VALUES
A character string representing additional information about the most recently executed query.
EXAMPLES
Example #1
Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
$maxdb->query("CREATE TABLE temp.t1 LIKE hotel.city");
/* INSERT INTO .. SELECT */
$maxdb->query("INSERT INTO temp.t1 SELECT * FROM hotel.city");
printf("%s
", $maxdb->info);
/* close connection */
$maxdb->close();
?>
Example #2
Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
maxdb_query($link, "CREATE TABLE temp.t1 LIKE hotel.city");
/* INSERT INTO .. SELECT */
maxdb_query($link, "INSERT INTO temp.t1 SELECT * FROM hotel.city");
printf("%s
", maxdb_info($link));
/* close connection */
maxdb_close($link);
?>
The above example will output something similar to:
Records: 25 Duplicates: 0 Warnings: 0
SEE ALSO maxdb_affected_rows(3), maxdb_warning_count(3), maxdb_num_rows(3).
PHP Documentation Group MAXDB_INFO(3)