E1: BSFN: How to Replace Characters in a String Using B0800780 or B0400520

(Doc ID 658313.1)

Last updated on FEBRUARY 14, 2018

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.

Goal

How can I find and replace any special characters used in a String with Blank or another character ? Can this be done using EnterpriseOne Event Rules ?  For example, for a string that contains special characters like commas, dashes ,etc. how can I replace these characters with a blank or another character.

EXAMPLE:
String:  Smith, John Tim
How can I format it to be "Smith John Tim"  or replace comma with dash instead  as "Smith- John Tim"?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms