I use rtf layout for report layout. When I export report query to excel format of apex version 19, i have one problem. More detail, now I return value in excel:
But I hope to return value in excel to that format: abcdefcgh. I try my best to adjust options for rtf layout. Thank everybody in advance. A challenge for me.
I am lucky for finding the statement for this case. It is called exactly name (remove line breaks). I provide that statement for anyone who need it as me.
replace(replace(emp.name, chr(13), ''),chr(10), ' ')
Thank eveyone again for viewing that question. If that request is not useful for everyone, I hope @Admin 'll remove it.