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:
An alternative way could be this:
RTRIM(my_column, CHR(10) || CHR(13))
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))
