07-27-2017
What would you like the result to look like?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a case where, I need to look into a file.
Go to each line of the file, find the length of the line, if the length of the line is more than 75 chars, I need to split the line into multiple lines of 75chars max. If the length of the line is less than 75, we need not do anything.
So at the... (4 Replies)
Discussion started by: thanuman
4 Replies
2. Shell Programming and Scripting
Can any one give me the idea on replacing multiple blank lines with a single blank line?
Please conside it for a file having more than 100 number of characters.
Regards,
Siba (3 Replies)
Discussion started by: siba.s.nayak
3 Replies
3. Shell Programming and Scripting
I have a file that contains the following:
:@:176:@:4:@:name:@:file:@:this is
a summary:@:description can be
long but who knows
can even have <br> tags.:@:how to:@:type:@:18544:@:550:@:400:END:
:@:177:@:9:@:name:@:file:@:summary:@:this
will containg... (18 Replies)
Discussion started by: sysrenan
18 Replies
4. Shell Programming and Scripting
Hi,
I've some files with the following data and i need to convert the lines between the separator ---, into a single line. I've tried with the paste cmd but my main problem is that the number of lines between the separator is not fix, it can very between 1-4 lines.
Input
---
2010-02-22... (4 Replies)
Discussion started by: RickyC9999
4 Replies
5. Shell Programming and Scripting
Hi,
I've some files with the following data and i need to convert the lines between the separator ---, into a single line. I've tried with the paste cmd but my main problem is that the number of lines between the separator is not fix, it can vary between 1-4 lines.
Input
---
2010-02-22... (8 Replies)
Discussion started by: RickyC9999
8 Replies
6. Shell Programming and Scripting
Hi,
I have a requirement with,
No~Dt~Notes
1~2011/08/1~"aaa
bbb
ccc
ddd
eee
fff
ggg
hhh"
Single column alone got splitted into multiple lines.
I require the output as
No~Dt~Notes
1~2011/08/1~"aaa<>bbb<>ccc<>ddd<>eee<>fff<>ggg<>hhh"
mean to say those new lines to be... (1 Reply)
Discussion started by: Bhuvaneswari
1 Replies
7. Shell Programming and Scripting
Hi,
1. Each message starts with date
2. There is blank line between each message
3. Each message does not contain same number of lines.
Any help in merging multiple lines in each message to a single line is much appreciated.
AIX: Korn Shell
Error log file looks like below.
... (5 Replies)
Discussion started by: bala123
5 Replies
8. Shell Programming and Scripting
Hi All ,
I have a file with below data
# User@Host: xyz @
# Query_time: t1 Lock_time: t2 Rows_sent: n1 Rows_examined: n2
SET timestamp=1396852200;
select count(1) from table;
# Time: 140406 23:30:01
# User@Host: abc @
# Query_time: t1 Lock_time: t2 Rows_sent: n1 Rows_examined:... (6 Replies)
Discussion started by: rakesh_411
6 Replies
9. Shell Programming and Scripting
Hi All,
I have a spool file which as shown below. I want to make it as single line after every semicolon. In this case there should be 2 lines in vi editor.
I am not used to use sed so could you guys please help me out ?
exec spk_dba.sp_runsql('ALP','CREATE DATABASE LINK "TEST" CONNECT TO... (2 Replies)
Discussion started by: nicolas38
2 Replies
10. Shell Programming and Scripting
Hi all, I'm relatively new to scripting, I can do pretty basic things. I have a daily log file that looks like:
timestamp=2017-06-28-01.01.35.080576;
event status=0;
userid=user1;
authid=user1;
application id=10.10.10.10.11111.12345678901;
application name=GUI;
... (29 Replies)
Discussion started by: dwdnet
29 Replies
LEARN ABOUT PHP
mysql_free_result
MYSQL_FREE_RESULT(3) 1 MYSQL_FREE_RESULT(3)
mysql_free_result - Free result memory
SYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_free_result(3)
oAssign the value of
NULL to the PDO object, or PDOStatement::closeCursor
bool mysql_free_result (resource $result)
DESCRIPTION
mysql_free_result(3) will free all memory associated with the result identifier $result.
mysql_free_result(3) only needs to be called if you are concerned about how much memory is being used for queries that return large result
sets. All associated result memory is automatically freed at the end of the script's execution.
o $
result -The result resource that is being evaluated. This result comes from a call to mysql_query(3).
Returns TRUE on success or FALSE on failure.
If a non-resource is used for the $result, an error of level E_WARNING will be emitted. It's worth noting that mysql_query(3) only returns
a resource for SELECT, SHOW, EXPLAIN, and DESCRIBE queries.
Example #1
A mysql_free_result(3) example
<?php
$result = mysql_query("SELECT id,email FROM people WHERE id = '42'");
if (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;
}
/* Use the result, assuming we're done with it afterwards */
$row = mysql_fetch_assoc($result);
/* Now we free up the result and continue on with our script */
mysql_free_result($result);
echo $row['id'];
echo $row['email'];
?>
Note
For backward compatibility, the following deprecated alias may be used: mysql_freeresult(3)
mysql_query(3), is_resource(3).
PHP Documentation Group MYSQL_FREE_RESULT(3)