Unable to remove next line character in .lst file (data retrieved using sql query)
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:]]',' ')