mutliple line data into single line

[sravanthi]

Hi,

I have a job db2...>trns...>seqential file.I'm extracting data and populating into a file.Source has 2 rows but when populated into file the file count is 10.

I have used
CONVERT(char(010),char(032),trim(fieldname)) in transformer to replace new line with space..but it is not working....

data is like this :

Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3
Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3

repeated lines.

It is a longvarchar(1500) field.I should get the data in single line instead of multiple lines.Please advise....

Thanks in advance

[ray.wurlod]

Are you sure that the delimiter character is Char(10)?

[sravanthi]

Ray,

I'm not sure of what delimiter it is .I have tried by looking at the data.

Is there any way to figure it out....sorry for this kind of question ...

[ray.wurlod]

Dump the data to a text file, and there examine it with a hex editor such as UltraEdit.

[sravanthi]

Dump the data to a text file, and there examine it with a hex editor such as UltraEdit. ...

Ray,

I have used ultaedit and when checked view line endings it was displaying at the end

Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3
Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3

Please advice.

Thanks!

[sravanthi]

Ray,

I have modified my code to CONVERT(char(012),char(032),trim(field name)) instead of CONVERT(char(010),char(032),trim(field name))

And now it is displaying in a single row.

Thanks!