How to remove ctrl M or(^M) characters in file using Sequential File stage?

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


Please Help Members By Posting Answers For Below Questions

What is datastage engine?

733


What is the purpose of pivot stage and types of containers in datastage

621


What is the process of killing a job in datastage?

597


How do you run datastage job from the command line?

609


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2088






What is a datastage job?

630


How to convert RGB Value to Hexadecimal values in datastage?

3468


Explain entity, attribute and relationship in datastage?

645


Define ds designer?

778


How many types of views are there in a datastage director?

843


Have you used Unstructured data?

841


Define project in datastage?

678


What are the main features of datastage?

672


What are the types of containers in datastage?

713


How one source columns or rows to be loaded in to two different tables?

668