BI Publisher (MOSC)

MOSC Banner

Unable to replace unknown symbols and characters from Beneficiary Name

edited Nov 25, 2018 2:15AM in BI Publisher (MOSC) 3 commentsAnswered

Dear All,

We want to remove the special characters and symbols from Beneficiary Name in Payment file.
We have used REPLACE function in BI publisher template but some of the unknown symbols and characters not able to identify to replace.

However, I have tried with REGEXP_REPLACE function in BI publisher template but the system did not recognize the REGEXP function.

Please advise any standard function available to replace symbols and characters.

Regards,

Anjana

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center