help for newbie -- using find() for exact match

[Slippy27]

I'm trying to modify a find/replace script which iterates through a file A and makes replacements defined in a csv file B. My original goal was to change any line in file A containing a search string (in whole or as a substring) defined in file B. File B contains both the search string and the string it should be changed into.

Example file A
whippy
slippy
ippy
slippy
snoob
flop
bloppy
inny
outy
slippie
blurg
lop

Example File B (substring,new form)
ippy,OOOOO
lop,TTTTTTT

But now I'd like to only make the change if there is an exact match. So the search string "ippy" should no longer cause "slippy" to change.

I tried changing "if search >= 1" to "if search == 1", but that makes zero changes.

I tried a simple test for equality like this "if line == old: data = data.replace(old, new)", but this fails because the lines within the for loop are just single characters, not whole words. For example, if I put a print line statement after "for line in data:", it prints each letter as a single line, like this (print ' for line =', line)
for line = w
for line = h
for line = i
for line = p
for line = p
for line = y
...

Any help would be greatly appreciated.

#original find_replace.py
import string, sys, os
import csv
 
myOut = open('out_replace.txt', 'w')
myFile = open("test_verb_list.txt","r")
data = myFile.read()
myFile.close()
 
changes = csv.reader(open('test_old_new.csv', 'rb'))
 
for line in data:
       for old, new in changes:
               search = string.find(data,old)
               if search >= 1:
                     data = data.replace(old, new)
 
print>>myOut, data
myOut.close()
 

[bvdet]

I'm trying to modify a find/replace script which iterates through a file A and makes replacements defined in a csv file B. My original goal was to change any line in file A containing a search string (in whole or as a substring) defined in file B. File B contains both the search string and the string it should be changed into.

Example file A
whippy
slippy
ippy
slippy
snoob
flop
bloppy
inny
outy
slippie
blurg
lop

Example File B (substring,new form)
ippy,OOOOO
lop,TTTTTTT

But now I'd like to only make the change if there is an exact match. So the search string "ippy" should no longer cause "slippy" to change.

I tried changing "if search >= 1" to "if search == 1", but that makes zero changes.

I tried a simple test for equality like this "if line == old: data = data.replace(old, new)", but this fails because the lines within the for loop are just single characters, not whole words. For example, if I put a print line statement after "for line in data:", it prints each letter as a single line, like this (print ' for line =', line)
for line = w
for line = h
for line = i
for line = p
for line = p
for line = y
...

Any help would be greatly appreciated.

#original find_replace.py
import string, sys, os
import csv
 
myOut = open('out_replace.txt', 'w')
myFile = open("test_verb_list.txt","r")
data = myFile.read()
myFile.close()
 
changes = csv.reader(open('test_old_new.csv', 'rb'))
 
for line in data:
       for old, new in changes:
               search = string.find(data,old)
               if search >= 1:
                     data = data.replace(old, new)
 
print>>myOut, data
myOut.close()
 

It would be appropriate to create a dictionary from the csv file data. You can test if each line, stripped of any whitespace, is in the dictionary with the in operator. Example:

import csv
 
csv_file = 'data_csv.csv'
data_file = 'data.txt'
 
change_list = [obj for obj in csv.reader(open(csv_file, 'rb'))]
changes_dict = dict(zip([item[0] for item in change_list],[item[1] for item in change_list]))
f = open(data_file)
for line in f:
    line = line.strip()
    print 'Original text: %s' % line
    line = changes_dict.get(line, line)
    print 'Final text: %s' % line
 
f.close()

[Slippy27]

EXCELLENT! This worked perfectly. Thread SOLVED!! Thanks!