Tuesday, 5 May 2015

REPLACECHR in Informatica

REPLACHR is used to replace one character with another or remove particular character from a string 

1.       REPLACECHR( CaseFlag, InputString, OldCharSet, NewChar )

 

Argument

Required/Optional

Description

CaseFlag

R

NULL or 0 -> Case-sensitive Other than 0 or NULL -> case insensitive.

InputString

R

String where character has to be replace

OldCharSet

R

Character which has to be matched, if two characters are provided they are treated as separate characters

NewChar

R

Replacement character. When more than one character is provided it replaces it with first character. If you want to replace one string with other or char with string use REPLACESTR


Example : Remove all the occurrences of A
 

1.       REPLACECHR(0,input,'A',NULL)

 

Input

Output

Apple

pple

Mapple

Mapple

AAA

NULL




 

 

 

 

 

 

Example : Replace vowels with b 

1.       REPLACECHR(1,input,'aeiou','b')

 

Input

Output

Apple

bpplb

Mapple

Mbpplb

AAA

bbb

 

No comments:

Post a Comment