Converting Multiple lines into single line

mydsworld · Post by **mydsworld** » Wed Sep 09, 2009 8:41 am

I have a column with longvarchar type that stores data in multiple lines. Please let me know how do I convert that into a single line.

Thanks.

DSguru2B · Post by **DSguru2B** » Wed Sep 09, 2009 8:49 am

User CONVERT() function on that particular column inside the transformer to convert new line characters into spaces.

chulett · Post by **chulett** » Wed Sep 09, 2009 8:51 am

... and a newline would be represented by CHAR(10).

nagarjuna · Post by **nagarjuna** » Wed Sep 09, 2009 1:43 pm

Also you acn use tr '\n' ' ' command

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Sep 09, 2009 2:11 pm

Unfortunately tr command may not help the op like the convert as the conversion is required for only one field.