A better replace function 1

[perplexd]

I am using a replace function to correctly capitalise a word. ie I want the word to be "PDXtra", which means that all versions: "pdxtra", "pdextra" and "pd extra" must be changed, no matter where in the word there are capitals.

Basically I need a replace function which looks at the letters, but not the case. If a word matches "pdextra" or "pdxtra" then it must be changed to "PDXtra".

Is there such a function, or must I go about writing it myself?

Many thanks for any replies!

 

[sunaj]

Hi, perplexed

Have you tried the vbBinaryCompare option of the replace function - that should do it... Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[johnwm]

If you want to achieve this

>'the word to be "PDXtra", which means that all versions: "pdxtra", "pdextra" and "pd extra" must be changed, no matter where in the word there are capitals.'

you will need to strip out the space before doing the compare
Let me know if this helps

Check out FAQ222-2244
'There are 10 kinds of people in the world: those who understand binary, and those who don't.'

 

[sunaj]

Johnwm is right about the space that has to be stripped.

I was a little fast on the keyboard, you should of course use vbTextCompare to replace independant of case...
(vbBinaryCompare is the default comparison method, which is case sensitive). X-)
Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[perplexd]

Cheers guys. The space is not an issue though:
NewText = Replace(NewText, "pd extra", "PDXtra", , , vbTextCompare)
This works with the space...