How to export line feed (introduced by excel) using query
I need to turn linefeed visible, introduced by excel, when extracting TS_description/DS_description for excel using query in Analisys View
How can I do this ? What function in Select statement?
Try using replace sql statement:
SELECT BUG.BG_BUG_ID /*Defect.Defect ID*/,REPLACE(REPLACE( BUG.BG_DESCRIPTION /*Defect.Description*/, CHAR(13),''), CHAR(10), '')
If you find this or any post resolves your issue, please be sure to mark it as an accepted solution"