How to replace the double quote in a string with Replace() function in Connect-It?

  • KM435603
  • 26-Mar-2008
  • 26-Mar-2008

Summary

The double quote character cannot be used directly as parameter in Replace() function...The ANSI encoding must be used.

Question

The double quote characters cannot be used directly as second parameters in replace() function because it must be between two double quotes.


Answer

To replace the double quote character in a string with the Replace() function, the use of ANSI encoding is mandatory.
So to replace the double quote in [Field1] by nothing, the script will be:
Replace([Field1], chr(34), "")