How to remove ctrl M or(^M) characters in file using Sequential File stage?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
how will u design file watch jobs?
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
What are the job parameters?
What are the partitioning techniques available in link partitioner?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
Explain datastage architecture?
What are the functionalities of link collector?
What is oci?
how can u handle null values in transformer stage.
What is the difference between an operational datastage and a data warehouse?
HOW CAN U DO ERROR HANDLING IN DATA STAGE?