APEX-AT-WORK no image

APEX CSV exports with strange line breaks inside

Von Tobias Arnhold 1.13.2010
I came across a problem with line breaks inside my automatically generated csv export.
It had to do with some field values which had some line breaks inside. I updated the effected columns like that:

select replace(replace(my_column,CHR(10),' '),CHR(13),' ') AS column_without_line_breaks,
from tbl_test

An alternative way could be this:
RTRIM(my_column, CHR(10) || CHR(13))

Post Tags: