Replace, but ignore certain characters

[Christopher M.]

I'd like to ignore certain characters when I use the replace function.

For instance if I want to replace the phrase:

'said I'

in the phrase:

'Jim said (I farted)'.

In order to do this it seems that I have to ignore the parentheses in 'said
(I'.


W. Pooh (AKA Winnie P.)

 

[Stuart McCall]

I'd like to ignore certain characters when I use the replace function.

For instance if I want to replace the phrase:

'said I'

in the phrase:

'Jim said (I farted)'.

In order to do this it seems that I have to ignore the parentheses in
'said (I'.


W. Pooh (AKA Winnie P.)

Try putting the string into a temp variable, replacing the parens with "",
then do the replace on that.

 

[Christopher M.]

Try putting the string into a temp variable, replacing the parens with "",
then do the replace on that.

What I really want to do is ignore formatting, when I do a replace.


W. Pooh (AKA Winnie P.)

 

[Stuart McCall]

What I really want to do is ignore formatting, when I do a replace.

Well presumably you know where the parens should appear in your replacement
string, so once you've stripped them out and done your replace, put them
back in.

 

[Christopher M.]

Well presumably you know where the parens should appear in your
replacement string, so once you've stripped them out and done your
replace, put them back in.

That should do the trick. Thanks.


W. Pooh (AKA Winnie P.)