Carriage return
Moderators: chulett, rschirm, roy
Carriage return
Hi
how do i remove carrier return problem from the data which i am reading in an excel sheet. I saved the excel sheet in tab delimited format but i cannot read the data properly which has carriage return on it. the carriage return becomes a new line in datastage, which is not correct.
Can anyone suggest what do i do?
Thanks
how do i remove carrier return problem from the data which i am reading in an excel sheet. I saved the excel sheet in tab delimited format but i cannot read the data properly which has carriage return on it. the carriage return becomes a new line in datastage, which is not correct.
Can anyone suggest what do i do?
Thanks
Re: Carriage return
Did you try to use "DOS line delimiter option" in the sequential file stage
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
I get the data in the form of spreadsheet which I need to read in datastage in a tab delimited file. I understand that I have to use SED but I dont see the ^M in my unix file. How will the SED work if i dont have it in my file.
Excel =>(save as tab delim) => Flat => Unix(no ^M)=>cannot use SED
sheet File (found)
I hope you understand this.
Excel =>(save as tab delim) => Flat => Unix(no ^M)=>cannot use SED
sheet File (found)
I hope you understand this.
I get the data in the form of spreadsheet which I need to read in datastage in a tab delimited file. I understand that I have to use SED but I dont see the ^M in my unix file. How will the SED work if i dont have it in my file.
Excel sheet =>(save as tab delim) => Flat file => Unix(no ^M not found)=>cannot use SED
I hope you understand this.
Excel sheet =>(save as tab delim) => Flat file => Unix(no ^M not found)=>cannot use SED
I hope you understand this.