Text file delivery: fields with line breaks

[oishimbo]

Hi guys and girls,

I have to extract data from SQL Server into text files. Quite easy, if there wasn't the minor issue that the text stored in one of the column contains line breaks, which will mess up my extract files.

Is there a way to mask the line break characters so that they don't introduce unwanted line breaks in the extract file?

Thanks for your help,

Oishimbo

[vincentsquirexiii]

I am also having problems with running reports with line breaks in PDF. I used replace function to substitute line breaks into a '.' (period) and is working on HTML, but on PDF, it is not working. I came accross a previous post regarding truncated reports in PDF...

I hope anyone has resolved this already.

[onevedrov]

Hi there.

try to modify the sql as following

SELECT Replace(Replace(FIELD_NAME, char(10), ''), char(13), '') as FIELD_NAME.....