Finding/replacing strings in some files based on a file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Finding/replacing strings in some files based on a file
Prev   Next
# 1  
Old 07-11-2012
Question 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!
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Finding similar strings between two files

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

2. Shell Programming and Scripting

Replacing strings in various files

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

3. Shell Programming and Scripting

Finding a text in files & replacing it with unique strings

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

4. Shell Programming and Scripting

Finding a format in a file and replacing it

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

5. Shell Programming and Scripting

Extended replacing of nonspecific strings in text files [beware complicated !]

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

6. Shell Programming and Scripting

Help with Awk finding and replacing a field based on a condition

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

7. Shell Programming and Scripting

Replacing Strings in a File

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

8. Shell Programming and Scripting

Replacing Strings in a File

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

9. Shell Programming and Scripting

Replacing strings in csv file.

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

10. Shell Programming and Scripting

replacing strings with text from other file

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
Login or Register to Ask a Question
ch_rc(1M)																 ch_rc(1M)

NAME
ch_rc - change system configuration file SYNOPSIS
root] {parameter|parameter=value}...] [file...] DESCRIPTION
manages the addition, modification, removal, and retrieval of information stored in files having the format of those in the directory. Parameter names are treated as strings. Thus, has no special meaning to in relation to other parameters named Options file Specify the file(s) to be used as the configuration database. If no file is specified, the set of files used by defaults to and all files in the directory. Modification and deletion of configuration parameters occurs in the file where the parameter is found. Add or modify a parameter definition. For each parameter specified on the command line, if the parameter is found in the specified (or default) files, it is modified to reflect the speci- fied value. If the parameter is not found, it is added to the specified file(s). If a new parameter is being defined, one or more files must be specified on the command line; the specified files are those in which the parameter will be defined. Remove a parameter definition. For each parameter name specified on the command line, remove any occurrence of that parameter from the specified file(s). List configuration values. For each parameter specified on the command line, output every definition of the parameter from the specified file(s). Output consists of only the values, one per line. Specify a parameter name or name/value pair. If a name and value is expected, but only a name is specified, the value will be set to the empty string. For example, specifying or will result in and respectively. Due to shell quoting rules, if you need a quoted parameter value, you must protect the quotes from the shell. For exam- ple, yields: which is an error, whereas, yields: Verbose. When used with the option, the option causes a verbose listing to be output. This listing includes a filename followed by the entire line containing the specified parameter for each occurrance of the parameter. The option is used to list all occurances of array parameters matching the parameters specified on the command line. For example, may emit the following output: Normally, the files specified on the command line are used as specified. By specifying a root directory with the option, all files (including the default files if none are specified) will be interpreted relative to root. For example, if root is specified as and is specified on the command line, it will be interpreted as RETURN VALUE
exits with one of the following values: 0 add/delete/list successful 1 command line syntax/usage error 2 can not access one or more of the listed (or default) files 3 can not open/create/write file 4 memory error 5 no files specified on command line for add option EXAMPLES
Files in the directory have the following format: WARNINGS
does not interpret configuration files; it only does pattern matching. As a result, if comments appear on lines containing parameter defi- nitions, the comments will also appear in output when using the option. cannot parse multiple parameter definitions which occur on the same line of a file. AUTHOR
was developed by HP. FILES
system configuration database driver file directory containing system configuration files SEE ALSO
rc.config(4). ch_rc(1M)