Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

REPLACESTR - Replace or Remove a single quote character in Informatica

  1. Forget Code
  2. Informatica
  3. REPLACESTR - Replace or Remove a single quote character
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