Almost anything is possible. I'm not sure what var1 & var2 are, but in theory this will work. Have you tried it? Did it give you some errors or just nothing?
I'm slightly confused by the change in the question. Back with the original post, I had prepared this answer already, so I'll share it anyway and see if that helps:-
Quote:
Rather than variables i, j & k, could you use an array? Something like:-
You should get the output lines trimmed and ready for use in the rest of your script as array elements of myvar indexed with a sequential number. Ignore the nodot variable, it's only temporary and has no further purpose.
The second loop in the script based on $l2 is just to display what you have extracted.
Where does that leave you? is the above any use?
Is your find command building the input that you want to process? We can work with that.
Hello there,
I need to remove carriage return characters (\n and \r) from any input file specified. This is what I am doing right now:
- dumping the file to octal format using the command 'od -c file_name
- removing and \s and \n characters using sed commands
What I need to do now is... (3 Replies)
I have file special.txt with the following data.
<header info>
123$ty5%98&0asd
1@356fgbv78
09*&^5jkns43(
...........some more rows.
In my output file, I want to eliminate all the special characters in my file and I want all other data. need some help. (6 Replies)
Hi
I have a file that has semicolons in it (;) is there a way to just remove these in the file. Example
name: Joe Smith; group: Group1;
name: Mary White; group: Group2; (2 Replies)
i have a file like this
1111_2222#$#$dudgfdk
11111111_343434#$#$334
1111_22222#43445667
i want to remove all those charachetrs from #
how can i do this
Thank in advance
Saravanan (4 Replies)
Hi,
I want to removing ^M characters from a file and combine the line with the next line.
ex:
issue i have:
ABC^M^M
DEF
solution i need:
ABCDEF
I found that you by using the following command you can remove new line characters.
tr -d '\r' < infile.csv > outfile.csv
still... (10 Replies)
Hi,
I have an csv file and there are some non printable characters(extended ascii) so I am trying to create a clean copy of the csv file . I am using
this command:
tr -cd "" < /opt/informatica/PowerCenter8.6.0/server/infa_shared/SrcFiles/ThirdParty/locations.csv > ... (4 Replies)
Hi,
We have a non printable character "®" in our file , we want to remove this character, we tried tr -dc '' < oldfile> newfile but this command is removing all new line entries along with the non printable character and all the records are coming in one line(it is changing the format of the... (2 Replies)
I have the following files in the same directory but if you look at the od
output you can see one of the files has and "\n" as part of the file
name.
Is there a way I can only remove the file with the "\n" as part of the
file name without affecting the other file.
I was thinking about... (4 Replies)
Hi,
I have many text files which contain some non-ASCII characters. I attach the screenshots of one of the files for people to have a look at. The issue is even after issuing the non-ASCII removal commands one of the characters does not go away. The character that goes away is the black one with a... (2 Replies)
Discussion started by: shoaibjameel123
2 Replies
LEARN ABOUT PHP
pdostatement.execute
PDOSTATEMENT.EXECUTE(3) 1 PDOSTATEMENT.EXECUTE(3)PDOStatement::execute - Executes a prepared statement
SYNOPSIS
public bool PDOStatement::execute ([array $input_parameters])
DESCRIPTION
Execute the prepared statement. If the prepared statement included parameter markers, you must either:
ocall PDOStatement.bindParam(3) to bind PHP variables to the parameter markers: bound variables pass their value as input and
receive the output value, if any, of their associated parameter markers
oor pass an array of input-only parameter values
PARAMETERS
o $input_parameters
- An array of values with as many elements as there are bound parameters in the SQL statement being executed. All values are
treated as PDO::PARAM_STR. You cannot bind multiple values to a single parameter; for example, you cannot bind two values to a
single named parameter in an IN() clause. You cannot bind more values than specified; if more keys exist in $input_parameters
than in the SQL specified in the PDO::prepare, then the statement will fail and an error is emitted.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.2.0 | |
| | |
| | The keys from $input_parameters must match the |
| | ones declared in the SQL. Before PHP 5.2.0 this |
| | was silently ignored. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
Execute a prepared statement with bound variables
<?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 an array of insert values (named parameters)
<?php
/* Execute a prepared statement by passing an array of insert values */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < :calories AND colour = :colour');
$sth->execute(array(':calories' => $calories, ':colour' => $colour));
?>
Example #3
Execute a prepared statement with an array of insert values (placeholders)
<?php
/* Execute a prepared statement by passing an array of insert values */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < ? AND colour = ?');
$sth->execute(array($calories, $colour));
?>
Example #4
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 #5
Execute a prepared statement using array for IN clause
<?php
/* Execute a prepared statement using an array of values for an IN clause */
$params = array(1, 21, 63, 171);
/* Create a string for the parameter placeholders filled to the number of params */
$place_holders = implode(',', array_fill(0, count($params), '?'));
/*
This prepares the statement with enough unnamed placeholders for every value
in our $params array. The values of the $params array are then bound to the
placeholders in the prepared statement when the statement is executed.
This is not the same thing as using PDOStatement::bindParam() since this
requires a reference to the variable. PDOStatement::execute() only binds
by value instead.
*/
$sth = $dbh->prepare("SELECT id, name FROM contacts WHERE id IN ($place_holders)");
$sth->execute($params);
?>
NOTES
Note
Some drivers require to close cursor before executing next statement.
SEE ALSO PDO.prepare(3), PDOStatement.bindParam(3), PDOStatement.fetch(3), PDOStatement.fetchAll(3), PDOStatement.fetchColumn(3).
PHP Documentation Group PDOSTATEMENT.EXECUTE(3)