String Replace with Mixed Case
Posted: Wed Sep 30, 2009 9:41 am
Hi,
I have a special case where I have to replace a word from a string with a mixed case string in a field, I know before hand what are the words that needs to be replaced with some special words.
I get a list of words from a Reference file as
OCONNELL=OConnell
LADISA=LaDisa
LADOUCEUR=LaDouceur
LADUCA=LaDuca
LADUCER=LaDucer
MCDONALD=McDonald
MCMILLER=McMiller
Etc...
When I get an input from the field as
123 Quality Drive MCDONALD Road CA USA
I should get the out put as
123 Quality Drive McDonald Road CA USA.
Any thoughts ?
Regards,
Shree
I have a special case where I have to replace a word from a string with a mixed case string in a field, I know before hand what are the words that needs to be replaced with some special words.
I get a list of words from a Reference file as
OCONNELL=OConnell
LADISA=LaDisa
LADOUCEUR=LaDouceur
LADUCA=LaDuca
LADUCER=LaDucer
MCDONALD=McDonald
MCMILLER=McMiller
Etc...
When I get an input from the field as
123 Quality Drive MCDONALD Road CA USA
I should get the out put as
123 Quality Drive McDonald Road CA USA.
Any thoughts ?
Regards,
Shree