Interested to Buy Any Domain ? << Click Here >> for more details...
How to remove ctrl M or(^M) characters in file using Sequential File stage?
- 2 Answers
- 22341 Views
- Bank Of America, Satyam, I also Faced
- E-Mail Answers
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 is the project in datastage?
What are the types of containers and how to create them?
Why do we use exception activity in Datastage?
what is the use of skid in reporting?
What is the different type of jobs in datastage?
How to RD using transformer?
Can you explain engine tier in information server?
State the difference between an operational datastage and a data warehouse?
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
What are the main differences you have observed between 7.x and 8.x version of datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
project Steps,hits, Project level HArd things,Solved methods?
Lookup constraints
What are routines in datastage?
