Six Stars

tMssqlOutput and Carriage Return / Line Break

I have a pretty simple sub-job that outputs to tMssqlOutput.  One of my string fields contains carriage return/line feeds.  These CR/LFs are being replaced with single spaces once they are inserted into the DB table.  Yet, if I replace the tMssqlOutput with a tLogRow the CR/LFs are present (and correct).


I don't ever recall having this issue before.  Any thoughts?


Thanks in advance!


Re: tMssqlOutput and Carriage Return / Line Break


Could you please elaborate your case with an example with input and expected output values?

Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.