TT0000013101257
|
JCJMMUJMMUB018
| Jul 3 2012 10:56AM |
JAMMU & KASHMIR
|
Hari Market
|
AIRCEL
| 9018611387 | 9018721313 | 9858399311 | NULL
TT0000013101355
|
WCSNDASNDAB001
| Jul 3 2012 11:00AM |
WEST BENGAL
|
Sanada
|
AIRCEL
| 9331110289 | 9331896477 | 9804199329
I have data in pipe separated form.
I want to remove all blank space and show it in one line.
I tried "cat temp | sed -e 's/ *| */|/g'" but its giving me O/P like
TT0000013101257|
JCJMMUJMMUB018|Jul 3 2012 10:56AM|
JAMMU & KASHMIR|
Hari Market|
AIRCEL|9018611387|9018721313|9858399311|NULL
TT0000013101355|
WCSNDASNDAB001|Jul 3 2012 11:00AM|
WEST BENGAL|
Sanada|
AIRCEL|9331110289|9331896477|9804199329|NULL
plz suggest script
| NULL
Moderator's Comments:
|
|
Duplicate Thread - Closed
|
|