var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Need to replace embedded newline characters in a column
I have a table in which a column has embedded newline (ascii 10) characters.
I need to replace the newline characters with something else - something distinct yet not a line break.
Does anyone have any idea how to do such a replace/update?
Thanks in advance,
select str_replace('this is line 1
and line 2',char(10),' - ')
Thank you. I was not familiar with that function.
use unix regex cmd
this strips the ^M off the eol
Originally Posted by chassemerrill
tr -d '\015' <file_in >file-out