My Oracle Support Banner

E1: BSFN: How to Replace Characters in a String Using B0800780 or B0400520 (Doc ID 658313.1)

Last updated on JUNE 12, 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
 
B0800780 - Strip Special Characters from String
 B0400520-Replace Character in a String
 Prevent unwanted replacement

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.