Print Page - Text file delivery: fields with line breaks

Title: Text file delivery: fields with line breaks
Post by: oishimbo on 05 Mar 2009 09:14:47 AM

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

Title: Re: Text file delivery: fields with line breaks
Post by: vincentsquirexiii on 12 May 2009 11:55:21 PM

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.

Title: Re: Text file delivery: fields with line breaks
Post by: onevedrov on 14 May 2009 08:55:50 AM

Hi there.

try to modify the sql as following

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

COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: oishimbo on 05 Mar 2009 09:14:47 AM