DSXchange

Hi,

In one of my source file we are getting new line character at the end of each row. I have to take care this in Data Stage.

I have used following fuction in derivation column, but new line character is not getting removed.

Ereplace(DSLink3.Desc,CHAR(8),'',-1,1)

I am trying to replace last digit in the record.

Can any help me on this?

Thanks.

The above function is Ereplace(DSLink3.TimeSubGrp,CHAR(8),'',-1,1)

sorry, When I submit CHAR 8 is getting replaced

Can you not edit the sequential file stage and add the newline to Format -> Record Level -> Record Delimiter?

rajendharreddy wrote:sorry, When I submit CHAR 8 is getting replaced

Hi,

U can use the convert in the transformer to remove the unwanted line

Convert('-','', inputcolumn)

i have replaced the '-' by null space ('')

Regards
Naveen.K

Change your line terminator to DOS-style in the stage properties of the Sequential File stage.