Issue in removing new line character

rajendharreddy · Post by **rajendharreddy** » Thu Jan 10, 2008 2:15 am

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.

rajendharreddy · Post by **rajendharreddy** » Thu Jan 10, 2008 2:17 am

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

rajendharreddy · Post by **rajendharreddy** » Thu Jan 10, 2008 2:18 am

sorry, When I submit CHAR 8 is getting replaced

ArndW · Post by **ArndW** » Thu Jan 10, 2008 4:02 am

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

naveen19 · Post by **naveen19** » Thu Jan 10, 2008 4:24 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Jan 10, 2008 4:45 am

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