How to remove ctrl M or(^M) characters in file using Sequential File stage?
Answer Posted / subhash (subbuchamala)
We can use these ways also to remove Control M Characters
tr -d '\r' < yourfile.txt > yourfile1.txt
mv yourfile1.txt yourfile.txt
or
Change the line terminator in Sequential File stage from
UNIX-style to DOS-style(it's a stage property).
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Define project in datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
table actions available in oracle connector?
What is the difference between the local container and shared container?
What is orabulk stage?
How do u convert the columns to rows in datastage?
What is ibm datastage flow designer?
What is datastage engine?
What steps should be taken to improve Datastage jobs?
What are stage variables and constants?
Define Routines and their types?
What are orabulk and bcp stages?
What all the types of jobs you developed?
Explain the situation where you have applied SCD in your project?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara