Batch Replace
Posted: Tue Jul 24, 2007 3:34 pm
Hi,
I have a text file and in that file I would like to do the following;
replace,
Table 1 with Jones J.
Table 2 with Jack K.
Table 3 with Jimmy A.
.
.
.
Table 10 with Sue B.
...
I created a csv file using M$ Excel and stored the replacement information there. I then imported the file into AFR and proceeded to execute the operation. The operation works fine up until Table 10 where Table 10 is replace with Jones J.1 and not Sue B. I have tried solving the problem using regular expressions but can't seem to figure it out(... in other words, I am looking for a regular expression that will find an exact phrase and not a subsection of that phrase). Can you please help me out with this problem?
Your cooperation will be deeply appreciated. Thanks.
Regards,
Jason.
I have a text file and in that file I would like to do the following;
replace,
Table 1 with Jones J.
Table 2 with Jack K.
Table 3 with Jimmy A.
.
.
.
Table 10 with Sue B.
...
I created a csv file using M$ Excel and stored the replacement information there. I then imported the file into AFR and proceeded to execute the operation. The operation works fine up until Table 10 where Table 10 is replace with Jones J.1 and not Sue B. I have tried solving the problem using regular expressions but can't seem to figure it out(... in other words, I am looking for a regular expression that will find an exact phrase and not a subsection of that phrase). Can you please help me out with this problem?
Your cooperation will be deeply appreciated. Thanks.
Regards,
Jason.