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
What a datastage macro?
What is the roundrobin collector?
What is the purpose of interprocessor stage in server jobs?
Notification Activity
How can you write parallel routines in datastage PX?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the purpose of pivot stage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are routines in datastage?
What are the different layers in the information server architecture?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What are the important features of datastage?
AGGREGATOR default datatype
What is ibm datastage?
What is the difference between odbc and drs stage?