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
- 22070 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
root tree will find which is server job and which is parallel job?
How a routine is called in datastage job?
What are transforms and what is the differenece between routines and transforms?
Where do you see different stages in the designer?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are datastage sequences?
What are constraints and derivations?
How many types of views are there in a datastage director?
Highlight the main features of datastage?
How do you generate sequence number in datastage?
Differentiate between operational datastage (ods) and data warehouse?
Is possible to create skid in dim,fact tables?
Difference between data warehousing and olap?
On which Dimension Table you implemented SCD Type in your Project
What is a ds designer?
