07-11-2012
Finding/replacing strings in some files based on a file
Hi,
We have a file (e.g. a .csv file, but could be any other format), with 2 columns: the old value and the new value. We need to modify all the files within the current directory (including subdirectories), so find and replace the contents found in the first column within the file, with the contents of the 2nd column
e.g. the file can contain:
COL1 -- COL2
old_one new_one
So for all .sql files, i want to replace the string 'old_one' with 'new_one'.
Is it possible this? If so, how?
Thanks!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Im trying to update some properties files with text from another file:
file1
user=xyz
file2
user=
after script
file2
user=xyz
Im using this reading the $QUARTZURL,ETC... from quartz.properties:
echo... (1 Reply)
Discussion started by: mc1392
1 Replies
2. Shell Programming and Scripting
Hi, I have a problem..
1) I have a file that contains the lines as below :
VRF-TM_DummyLab/mse02.lab,mse02.lab,ge-2/0/7.222
VRF-EMS_HUAWEI_MSAN_208/mse01.lab,mse01.lab,xe-1/0/0.208
2) I need a method to read this file, line by line
from :... (5 Replies)
Discussion started by: msafwan82
5 Replies
3. Shell Programming and Scripting
I have a input file which looks like this:
Value1=""
Value2=""
Value3=""
ListOfValues=" $Value1 $Value2 $Value3"
I have another program which computes the values ($val1, $val2, $val3). So if $val1 is 'A', $val2 is 'B' and $val3 is 'C', I should edit the input file so it will look like:... (0 Replies)
Discussion started by: laiko
0 Replies
4. Shell Programming and Scripting
I have a input file which looks like this:
Value1=""
Value2=""
Value3=""
ListOfValues=" $Value1 $Value2 $Value3"
I have another program which computes the values ($val1, $val2, $val3). So if $val1 is 'A', $val2 is 'B' and $val3 is 'C', I should edit the input file so it will look like:... (6 Replies)
Discussion started by: laiko
6 Replies
5. Shell Programming and Scripting
Hi everybody,
I'm trying to replace the $98 field with "T" if the last field (108th) is T
I've tried
awk 'BEGIN{OFS=FS="|"} {if ($108=="T")sub($98,"T"); print}' test.txt
but that doesn't do anything
also tried
awk 'BEGIN{OFS=FS="|"}{ /*T.$/ sub($98,"T")} { print}' test.txt
but... (2 Replies)
Discussion started by: jghi123
2 Replies
6. Shell Programming and Scripting
Well, to make another post at this helpful forum :b::D:
I recently tried something like this, I want to replace all those numberings/letters that are located
between <string>file://localhost/var/mobile/Applications/ and /Documents/</string>
numberings =----
replace with:
first... (6 Replies)
Discussion started by: pasc
6 Replies
7. Shell Programming and Scripting
Hi,
I need help in the following:
I have a file in directory with mutiple comma seperated values. One of the value is a date and time format like 2012-04-10 xx:yy:zz
I need to find that time format in the file and then replace it with xx:yy+1:zz
and then save it as a new file and copy it to a... (3 Replies)
Discussion started by: rabh
3 Replies
8. Shell Programming and Scripting
Hallo Everyone.
I have to admit I'm shell scripting illiterate . I need to find certain strings in several text files and replace each of the string by unique & corresponding text.
I prepared a csv file with 3 columns: <filename>;<old_pattern>;<new_pattern>
... (5 Replies)
Discussion started by: gordom
5 Replies
9. Shell Programming and Scripting
i'm trying to figure out the easiest way to replace a string:
pineapple pineapple-reg
basketball basketball-reg
football foot-reg-ball
i'm storing the above in a file called wordstoreplace.txt
for each line above, the word in the first column is to be replaced by the word in the second... (4 Replies)
Discussion started by: SkySmart
4 Replies
10. UNIX for Dummies Questions & Answers
Hi,
I have a file1 like this:
ABAT
ABCA1
ABCC1
ABCC5
ABCC8
ABCE1
ABHD2
ABL1
CAMTA1
ACBD3
ACCN1
And I have a second file like this:
chr19 46118590 46119564 MACS_peak_1499 3100.00 chr19 46122009 46148405 CYP2B7P1 -2445
chr1 7430312 7430990... (7 Replies)
Discussion started by: a_bahreini
7 Replies
LEARN ABOUT PHP
db2_fetch_object
DB2_FETCH_OBJECT(3) 1 DB2_FETCH_OBJECT(3)
db2_fetch_object - Returns an object with properties representing columns in the fetched row
SYNOPSIS
object db2_fetch_object (resource $stmt, [int $row_number = -1])
DESCRIPTION
Returns an object in which each property represents a column returned in the row fetched from a result set.
PARAMETERS
o $stmt
- A valid stmt resource containing a result set.
o $row_number
- Requests a specific 1-indexed row from the result set. Passing this parameter results in a PHP warning if the result set uses a
forward-only cursor.
RETURN VALUES
Returns an object representing a single row in the result set. The properties of the object map to the names of the columns in the result
set.
The IBM DB2, Cloudscape, and Apache Derby database servers typically fold column names to upper-case, so the object properties will
reflect that case.
If your SELECT statement calls a scalar function to modify the value of a column, the database servers return the column number as the
name of the column in the result set. If you prefer a more descriptive column name and object property, you can use the AS clause to assign
a name to the column in the result set.
Returns FALSE if no row was retrieved.
EXAMPLES
Example #1
A db2_fetch_object(3) example
The following example issues a SELECT statement with a scalar function, RTRIM, that removes whitespace from the end of the column.
Rather than creating an object with the properties "BREED" and "2", we use the AS clause in the SELECT statement to assign the name
"name" to the modified column. The database server folds the column names to upper-case, resulting in an object with the properties
"BREED" and "NAME".
<?php
$conn = db2_connect($database, $user, $password);
$sql = "SELECT breed, RTRIM(name) AS name
FROM animals
WHERE id = ?";
if ($conn) {
$stmt = db2_prepare($conn, $sql);
db2_execute($stmt, array(0));
while ($pet = db2_fetch_object($stmt)) {
echo "Come here, {$pet->NAME}, my little {$pet->BREED}!";
}
db2_close($conn);
}
?>
The above example will output:
Come here, Pook, my little cat!
SEE ALSO
db2_fetch_array(3), db2_fetch_assoc(3), db2_fetch_both(3), db2_fetch_row(3), db2_result(3).
PHP Documentation Group DB2_FETCH_OBJECT(3)