Instead of "" if you substitute with chr(32) it strips,
that is in your example it will displayed as 1 3 (with space between 1 and 3)
but ofcourse as you said if you want to join these two again,
you have to use instr, len and mid function depending on your need.
Originally posted by rnealejr
You can use the replace function to remove the apostrophe or to add an additional apostrophe if you are trying to keep the single quote in the database.
This replace function.....will it work dynamicaly, you see i dont know where in the string the ' will be it is up to the end use and the selection that he makes. Can you give me more info on replace?
' you can use do while and INSTR fce - it can be faster....
For i = 1 To Len(InputString)
If Mid(InputString, i, 1) = ReplaceThisChar Then
InputString = Left(InputString, i - 1) & WithThisChar & Mid(InputString, i + 1)
ReplaceString = InputString
then you can try
? ReplaceString ("Hi 'this' is me","'","")
? ReplaceString ("Hi 'this' is me","'",chr(34))