I am debugging some code, and come accross the below, could sopmeone please explain what this is actually doing? and why there are many oReplace here? i'd like to simply this staement so any pointers will be great.
SyntaxEditor Code Snippet
SUBSTR(td_sysfnlib.oREPLACE(td_sysfnlib.oREPLACE(td_sysfnlib.oREPLACE(UPPER(COALESCE (td_sysfnlib.REGEXP_REPLACE ( td_sysfnlib.oREPLACE (td_sysfnlib.oREPLACE ( REQ.CUST_FRST_NAME , '�' , 'E' ) , '�' , 'ss' ) , '([������])' , '\1e' ), 'Null')), '�', 'O'),'�', 'U'), '�', 'A'),1,5)
Seems to be replacing certain non-ASCII characters ("sharp s", vowels with diacritical marks) with their "latinized" spellings.
If you're asking why use multiple OREPLACE for the single-character replacements instead of, say, OTRANSLATE, you'd have to ask the author.