11-14-2008
Is this a homework or sth?
try this,
tr -s " " < filename > outfile
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I know we can substitute a string using sed but how?
For example: sed 's/(old variable)/(new variable)/ details.dat
Am I suppose to put $old variable or whatever? Because I tried many times, it didnt work by putting $old variable. Am I suppose to enclose it with "" or ''?
Please help (3 Replies)
Discussion started by: Ohji
3 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I have a set of files containing strings like I.TEST1_TEST2 or B.ESSA_ESSB for example.
Does somebody know how to substitute these strings whith the same name and an extension "_V1" (ie. I.TEST1_TEST2_V1) using sed command or else ? (3 Replies)
Discussion started by: jo_aze
3 Replies
3. Shell Programming and Scripting
Hi ,
I am stuck up in the below scenario:-
I need to read a file name (eg A.txt) name frm another file (eg B.txt) and then I need to search for a particular expression in A.txt and substitute it with another expression.
How can I use SED inside SHELL Scripting and command prompt as... (2 Replies)
Discussion started by: shubhranshu
2 Replies
4. Shell Programming and Scripting
Hi ,
I am stuck up in the below scenario:-
I need to read a file name (eg A.txt) name frm another file (eg B.txt) and then I need to search for a particular expression in A.txt and substitute it with another expression.
How can I use SED inside SHELL Scripting and command prompt as well to... (1 Reply)
Discussion started by: shubhranshu
1 Replies
5. Shell Programming and Scripting
Hi I am trying to do a text insertion in a text file at a particular line number in a shell script. However its not working.
sed '122i\
> for j in \`echo $MyList\` ; do perl -pi -e\'s#01\/01\/2009#01\/01\/2011#\' $j ; done' $HOME/MyScript.ksh
The Actual line to be inserted at line 122... (5 Replies)
Discussion started by: som.nitk
5 Replies
6. UNIX for Dummies Questions & Answers
I'm a noob to unix, and I have a line of data like the following:
title=Boston|tcolor=green|desc=Large city in New England|url=www.boston.com
Is there a way to change a field value with sed substitution?
(i.e. change tcolor=green to tcolor=blue)
I figured out: sed... (19 Replies)
Discussion started by: stabby
19 Replies
7. Shell Programming and Scripting
I have a file with some numbers having single quotes around them which I want to remove.
i.e. '923930' -> 23930
If it can be done without using sed thats fine. I have tried with sed but can't think how to replace this pattern on only the numbers (13 Replies)
Discussion started by: user_invalid
13 Replies
8. Shell Programming and Scripting
Hello,
I have two files. File1 is normal txt file and File2 contains list of line numbers.
e.g. File2:
3
6
9
.....
I need to replace a character in File1 in lines (taken from File2). For that I am using a "for" loop:
for i in $(cat File2)
do
sed "$i s/Y/N/" File1
done
but my... (3 Replies)
Discussion started by: shekhar2010us
3 Replies
9. UNIX for Dummies Questions & Answers
How can you use sed with a line of code that reads:
67899:Bill:Williams:Maple Dr.:45908600
Let us say we want to replace Maple Dr. with Oak St. (1 Reply)
Discussion started by: yonkers062986
1 Replies
10. Shell Programming and Scripting
Hi everyone,
I need very simple sed command to change a parameter in a text file.
I have a line in this text which is like
set xx 0.5
A program reads this file and does some algebraic calculations. So to make a parameter scan I need to change the value of xx. I thought I can do... (7 Replies)
Discussion started by: hayreter
7 Replies
LEARN ABOUT PHP
pdostatement.bindparam
PDOSTATEMENT.BINDPARAM(3) 1 PDOSTATEMENT.BINDPARAM(3)
PDOStatement::bindParam - Binds a parameter to the specified variable name
SYNOPSIS
public bool PDOStatement::bindParam (mixed $parameter, mixed &$variable, [int $data_type = PDO::PARAM_STR], [int $length], [mixed
$driver_options])
DESCRIPTION
Binds a PHP variable to a corresponding named or question mark placeholder in the SQL statement that was used to prepare the statement.
Unlike PDOStatement.bindValue(3), the variable is bound as a reference and will only be evaluated at the time that PDOStatement.execute(3)
is called.
Most parameters are input parameters, that is, parameters that are used in a read-only fashion to build up the query. Some drivers support
the invocation of stored procedures that return data as output parameters, and some also as input/output parameters that both send in data
and are updated to receive it.
PARAMETERS
o $parameter
- Parameter identifier. For a prepared statement using named placeholders, this will be a parameter name of the form $:name. For a
prepared statement using question mark placeholders, this will be the 1-indexed position of the parameter.
o $variable
- Name of the PHP variable to bind to the SQL statement parameter.
o $data_type
- Explicit data type for the parameter using the PDO::PARAM_* constants. To return an INOUT parameter from a stored procedure, use
the bitwise OR operator to set the PDO::PARAM_INPUT_OUTPUT bits for the $data_type parameter.
o $length
- Length of the data type. To indicate that a parameter is an OUT parameter from a stored procedure, you must explicitly set the
length.
o $driver_options
-
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Execute a prepared statement with named placeholders
<?php
/* Execute a prepared statement by binding PHP variables */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < :calories AND colour = :colour');
$sth->bindParam(':calories', $calories, PDO::PARAM_INT);
$sth->bindParam(':colour', $colour, PDO::PARAM_STR, 12);
$sth->execute();
?>
Example #2
Execute a prepared statement with question mark placeholders
<?php
/* Execute a prepared statement by binding PHP variables */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < ? AND colour = ?');
$sth->bindParam(1, $calories, PDO::PARAM_INT);
$sth->bindParam(2, $colour, PDO::PARAM_STR, 12);
$sth->execute();
?>
Example #3
Call a stored procedure with an INOUT parameter
<?php
/* Call a stored procedure with an INOUT parameter */
$colour = 'red';
$sth = $dbh->prepare('CALL puree_fruit(?)');
$sth->bindParam(1, $colour, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 12);
$sth->execute();
print("After pureeing fruit, the colour is: $colour");
?>
SEE ALSO
PDO.prepare(3), PDOStatement.execute(3), PDOStatement.bindValue(3).
PHP Documentation Group PDOSTATEMENT.BINDPARAM(3)