Replacing ASCII characters to Hyphen on the eText extract — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Replacing ASCII characters to Hyphen on the eText extract

edited Nov 6, 2024 9:46AM in HCM Extract

I'm using REPLACE(PER_LAST_NM,'''','-') and it's not working .

I want this name O'Hara to be changed to O-Hara

i want that Single Quote removed and change it to Hyphen .

Thanks

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!