Converting CR and LF to Empty stirng

[mac4rfree85]

Hi Guys,

I like to convert CR and LF which is coming in a particular column to Empty string.

I tried the following but it was not converted.

Code: Select all

Convert('chr(10)chr(13)','',COLNAME)

Can somebody help me with this.

Cheers!!!

[Ravi.K]

Try using below derivation.

Covert(char(13),'',Convert(char(10),'',COLNAME))

[chulett]

I tried the following but it was not converted.

You quoted the char functions you were attempting to use so they just turned into a 14 character string.

[ray.wurlod]

You also used incorrect function names, and did not concatenate them.

The correct equivalent for your expression is

Code: Select all

Convert(Char(10) : Char(13), "", InLink.COLNAME)

However there is a cost in evaluating the Char() function. More efficient would be to create a stage variable, let's call it svCRLF, initialized to Char(13) : Char(10), and not given a derivation for each row. Then the expression becomes

Code: Select all

Convert(svCRLF, "", InLink.COLNAME)

[mac4rfree85]

Yeah Ray, i found it later.. thanks anyway..