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 |
0Awesome Comments!