How to remove ctrl M or(^M) characters in file using Sequential File stage?
Answer Posted / subbuchamala
1) In Sequential file, we have an option like 'filter'.
in the filter we can mention like:
sed 's/\^M//g' FileName.txt
or
2) we can do this in Before job routine(executeSH) and we can cal this in Seq file stage. here we can use UNIX command 'unix2dos fileName.txt'
Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Where do the datastage jobs get stored?
how to export or import the jobs in .ISX file
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is "fatal error/rdbms code 3996" error?
How do you start developing a datastage project?
How do you run datastage job from the command line?
What are the functionalities of link collector?
If you want to use a same piece of code in different jobs, how will you achieve this?
Can you explain kafka connector?
How to implement complex jobs in data stage?
What are some prerequisites for datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
how to abort the job its matain duplicates?
What is the method of removing duplicates, without the remove duplicate stage?
What are data elements?