How to remove control M or special character by ds jobs
Moderators: chulett, rschirm, roy
How to remove control M or special character by ds jobs
Hi,
We can remove the control m or special characters in UNIX scripts.. but
is there any way to remove the special characters coming in flat files from Datastage jobs?
We can remove the control m or special characters in UNIX scripts.. but
is there any way to remove the special characters coming in flat files from Datastage jobs?
Mayura
Yes, there are various ways and which method is used depends upon how you read the files. Are the Control-M characters in strings in the job? If yes, then a simple Convert(Char(13),'',In.ColumnName) will do the trick.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
This, typically. But as Arnd noted there are various ways so it really depends on the where and the what of it.Sainath.Srinivasan wrote:If ^M is at the end of the record, it may be due to DOS type record termination. Setting this property will handle it properly.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: