The problem is that the sed does not work with the sample data (even after changing date to Date). It replaces the pattern between the first and last double quote character, such that the other two fields disappear!
how can i modify a file using sed when searching
for a pattern and insert newline after the pattern?
pattern example: $ ...(any characters)...$
$ may082001.../tmp/msg.001,,$ REPT CLEAR ALARMS ON UNIT 1
$ may082001.../tmp/msg.002,,$ UNIT 1 IN SERVICE
into:
$... (1 Reply)
Hi,
I'm using the following to insert lines into file:
sed ${rowNr}i'\
first row\
second row\
third row\
' file.txt
How can I add tab in front of each added line? "\t" or actual TAB does not seem to work?
Thanks! (2 Replies)
I am running a Informix-4GL program to insert/update/delete on a particular table (say xxx). Now I want to create a logfile in unix which will store the affected data(say xxx.*) along with user information (say uname,IP address etc.)
what command I should use from Informix-4GL ?
I have tried the... (0 Replies)
Hi,
I have delimited file(|).
Sample data:
1|name|50009|DS24|0|12
2|name|30009|DS24|0|13
3|name|20409|DS24|0|14
4|name|20009|DS24|0|15
5|name|10009|DS24|0|16
I want to load this data into a oracle table (update and insert)
Please help me the commands and also... (1 Reply)
Hi all,
I have a file like this
Q8N302
21-84
Q8N157
15-45
Q99996
167-201
202-251
269-318
I want to insert a character or space if the line starts with a number and I used the command
sed 's/^/#/'
But in the output file, when it inserts this character, first digit in the number is... (2 Replies)
Hi all,
I have a file called "text.cpp" with the first line of "1"
afterwards I tried in Ubuntu to type the following
sed '12iasdasdasdasdsad' test.cpp > output.txt
however when I tried to see the result of output.txt
#cat output.txt
1
why is the line 12 is not updated to the... (6 Replies)
I'm in the process of being forward-thinking and finally converting my site's db to UTF-8. I've already done the UTF-8 conversion (on a copy for testing) and now I want to go through and convert html entities to their actual characters.
I ran an entity decode on a mysqldump file but realized... (10 Replies)
Right I have a MYSQL database with table1 with 3 columns, colA, colB and colC. I want to combine the data in the 3 columns into a 4th column names col_comb. Here's the SQL command that works:
UPDATE table1 SET `col_comb` = CONCAT( `colA` , ' - ', `colB` , ', ', `colC` );
So now I want this... (5 Replies)
Hi folks,
I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex.
I have a bunch of update statements with all columns in a file which I need to convert into insert statements.
UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
I have a problem with my shell script. I want to insert data from file to table1(empty) and then, compare table1 with table2 and update some fields.
The first part is correct, but the second part does not work. The only way it works is if after the first part I truncate table1 and run the script... (1 Reply)
Discussion started by: nika_mill
1 Replies
LEARN ABOUT PHP
imap_mailboxmsginfo
IMAP_MAILBOXMSGINFO(3) 1 IMAP_MAILBOXMSGINFO(3)imap_mailboxmsginfo - Get information about the current mailboxSYNOPSIS
object imap_mailboxmsginfo (resource $imap_stream)
DESCRIPTION
Checks the current mailbox status on the server. It is similar to imap_status(3), but will additionally sum up the size of all messages in
the mailbox, which will take some additional time to execute.
PARAMETERS
o $
imap_stream -An IMAP stream returned by imap_open(3).
RETURN VALUES
Returns the information in an object with following properties:
Mailbox properties
+--------+----------------------------------------+
| Date | |
| | |
| | date of last change (current datetime) |
| | |
|Driver | |
| | |
| | driver |
| | |
|Mailbox | |
| | |
| | name of the mailbox |
| | |
| Nmsgs | |
| | |
| | number of messages |
| | |
|Recent | |
| | |
| | number of recent messages |
| | |
|Unread | |
| | |
| | number of unread messages |
| | |
|Deleted | |
| | |
| | number of deleted messages |
| | |
| Size | |
| | |
| | mailbox size |
| | |
+--------+----------------------------------------+
Returns FALSE on failure.
EXAMPLES
Example #1
imap_mailboxmsginfo(3) example
<?php
$mbox = imap_open("{imap.example.org}INBOX", "username", "password")
or die("can't connect: " . imap_last_error());
$check = imap_mailboxmsginfo($mbox);
if ($check) {
echo "Date: " . $check->Date . "<br />
" ;
echo "Driver: " . $check->Driver . "<br />
" ;
echo "Mailbox: " . $check->Mailbox . "<br />
" ;
echo "Messages: " . $check->Nmsgs . "<br />
" ;
echo "Recent: " . $check->Recent . "<br />
" ;
echo "Unread: " . $check->Unread . "<br />
" ;
echo "Deleted: " . $check->Deleted . "<br />
" ;
echo "Size: " . $check->Size . "<br />
" ;
} else {
echo "imap_mailboxmsginfo() failed: " . imap_last_error() . "<br />
";
}
imap_close($mbox);
?>
PHP Documentation Group IMAP_MAILBOXMSGINFO(3)