Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Removing line-breaks from CSV

user637544Aug 25 2009 — edited Sep 11 2009

Hi, I have an Excel file which I am converting to CSV. The excel field may contain newline character. So while converting it to CSV, the field with newline character causes a line break.
The delimiter I am using is pipe '|'. I have 10 fields in my excel. I want to remove all newline characters from between field 1 and field 10 so that only genuine new line characters appear only when a new record comes. How can I do it in Unix?

This post has been answered by Tommy.Reynolds-Oracle on Aug 26 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2009

Added on Aug 25 2009

#generic-linux, #linux

13 comments

11,560 views