SQL Language (MOSC)

MOSC Banner

Unable to remove next line character in .lst file (data retrieved using sql query)

in SQL Language (MOSC) 5 commentsAnswered ✓

We have a requirement to query the database for specific columns and store the output in a .lst file. When executing the query the data is retrieved without any new line characters for the problem column but when the same query is being used to retrieve the output and store in .lst file the problem column appears always in the next line. Tried to remove the new line character using multiple options like below:

REPLACE(REPLACE(substr(trim(c.dln),1,22),chr(13),''),chr(10),'')

regexp_replace(dln,'[^0-9]')

regexp_like(dln,'[[:alnum:]]')

regexp_replace(dln,'[[:space:]]',' ')

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