Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Find and remove Space( ) & Hyphen(-) from string value.

edited Mar 21, 2016 11:00AM in Design Tools & Output Technologies - JDE1 (MOSC) 8 commentsAnswered

Dear All,

There is a string value exist in a field column named Location (LOCN) in Table: F4111.

Column consist of string including white space and hyphen/dash(-).

For Ex.: 1234-AB  -     - 43AX-

Now, we would like to remove the the space and - from this column.

So, after conversion it will be looks like: 1234AB43AX.

Is there any String Function/Business Function which identify and remove the such characters and save the remaining string in same record?

Product Details:

JDE E1 Version 9.1 with Tool Release 9.1.4.4.

Thanks,

Vishal Shah

Tagged:

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