REPLACESTR - Replace or Remove a single quote character in Informatica

Single quot character is treat as string operator in informatica. What if your input had single quote in the string and you want to remove them. Use the following code
REPLACESTR(1,input,CHR(39),NULL)

InputOutput
Adam's AppleAdams Apple
John'sJohns
JohnyJohny


The above code removes the single quote character, and if you want to replace it with another character replace NULL with your character in above code