Introducing Radical.sh

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

REPLACESTR - Replace a string with another string in Informatica

  1. Forget Code
  2. Informatica
  3. REPLACESTR - Replace a string with another string
REPLACESTR is used when one input string (or more) has to be replaced with another string. Note the following example replace ab and bc with *

Example : Replace old with new 
REPLACESTR ( 1, INPUT, 'old', 'new')

INPUTRETURN VALUE
oldnew
oldkeyboardnewkeyboard
old mousenew mouse
holdhnew

Example : More than input with one replacement 
REPLACESTR ( 1, INPUT, 'ab', 'bc', '*' )

INPUTRETURN VALUE
abc*c
abbc**
abbbbc*bb*
bc*