Hi gurus, hoping someone can help with a sed line that can do the following...
I have a flat file with about 1000 records, but in order to import into openoffice spreadsheet, I need to create a delimited file. I'd like to do 2 things with the SED command:
1- add a pipe character "|" at the end of each line
2- (the above will create a double pipe for every two blank links, such as ||). Replace the || double-pipe with carriage returns so in the end I have a delimited file. Im not rigid on how to perform step 2, so any recommendations are appreciated. See the file format below for a better view.
The file format is like this:
Person1
Address
Value1
License Status blah blah blah
<2 carriage returns>
Person2
Address
Value1
License status.. blah...
<2 Carriage returns>
etc...
After running the text file through a SED command, i'd like the file to look like this:
Person1|Address|Value1|License Status blah blah blah
Person2|Address|Value1|License status.. blah...
Person3|etc...
Any help is greatly appreciated! Thanks in advance!