9

how to read multi line characters in a single column

view full story
linux-howto

http://www.unix.com – Hi, I have file in which fields are pipe (|) separated and the record separator is new line (\n). But sometime I am getting a field value which is spread across multiple line. Basically I am getting a file from another system in the below format and needs to process the file and load data into a db using an ETL tool. For Example: Id | Company Name | Address | City | Country <--- Header Actual Data: 001| MS | ABC PVT LTD, A BLOCK, PARK STREET | Bangalore | India 002| IBM | XYZ LTD, TR STREET | NJ | USA The expected output should be : 001| MS | ABC PVT LTD, A BLOCK, PARK STREET (HowTos)