E1: BSFN: How To Replace Carriage Return With a Space Character in a String (Doc ID 644562.1)

Last updated on JANUARY 24, 2023

Applies to:

Goal

You are using the ER system function <Get Text> to retrieve media object text. The text / string is made up of several lines; you need to replace the carriage return (CR or \r) and linefeed (LF or \n) characters at the end of every line with a space so that the text is in a single line for data export. Is there an existing business function that will do this?

Solution

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