devxlogo

Converting a return to a blank space

Converting a return to a blank space

Question:
I am using SQL+ through COBOL to include a 250 char notes field on a report. If the user has entered a return character in the field (Hex 0A), can I use Translate or Convert to convert this return character into a space when selecting this notes field?

Answer:
You can search for char(10)+char(13) and make it a CHAR(32).

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist