K
Kathy R.
Hi Folks,
I have a field [MaidenName] that contains parenthesis, which I'd like to
remove.
Currently the data in the field looks like:
(Miller)
There's only 120 names that need to have the parenthesis stripped. By
the time I figure out how to do this in a query I could have done it by
hand, but I am determined to learn how to do this!
I've managed to strip the left paren with the following, but can't
figure out how to get rid of the right one:
MaidFix:
Mid([SP_MaidenName],InStr([SP_MaidenName],'(')+1,Len([SP_MaidenName])-InStr([SP_MaidenName],'
'))
Is there an easier way? If not, how do I change the statement above to
remove the right paren?
Your help is very much appreciated!
Kathy R.
I have a field [MaidenName] that contains parenthesis, which I'd like to
remove.
Currently the data in the field looks like:
(Miller)
There's only 120 names that need to have the parenthesis stripped. By
the time I figure out how to do this in a query I could have done it by
hand, but I am determined to learn how to do this!
I've managed to strip the left paren with the following, but can't
figure out how to get rid of the right one:
MaidFix:
Mid([SP_MaidenName],InStr([SP_MaidenName],'(')+1,Len([SP_MaidenName])-InStr([SP_MaidenName],'
'))
Is there an easier way? If not, how do I change the statement above to
remove the right paren?
Your help is very much appreciated!
Kathy R.