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
What is use Array size in datastage
What are the functionalities of link partitioner?
in oracle target stage when we use load option and when we use upsert option?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Is possible to create skid in dim,fact tables?
What is the difference between in process and inter process?
What are the benefits of datastage?
What are datastage sequences?
What are orabulk and bcp stages?
Can you explain link buffering?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
how to implement scd2 in datastage 7.5 with lookup stage
What is a merge?
explain about citrix scheduling tool in datastage
How a server job can be converted to a parallel job?