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.
Issue in removing new line character
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Tue Aug 21, 2007 5:39 am
- Location: Bangalore, India
-
- Participant
- Posts: 46
- Joined: Tue Aug 21, 2007 5:39 am
- Location: Bangalore, India
-
- Participant
- Posts: 46
- Joined: Tue Aug 21, 2007 5:39 am
- Location: Bangalore, India
Can you not edit the sequential file stage and add the newline to Format -> Record Level -> Record Delimiter?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: