Removing blanks, spaces

Shell Programming and Scripting
1

I have pipe separated file with lots of blank spaces.

After using sed -e 's/ *| */|/g' this command ,its giving me output as

TT0000013101640|
         HCAMBLAMCNB010|Jul  3 2012 11:14AM|
         HARYANA|
         Bangali Mohalla |
         TCL-UBR|9368040005|9355264655|9218509220|NULL 
 TT0000013101695|
         QCKNKEKKUIB001|Jul  3 2012 11:17AM|
         JHARKHAND|
         Kathkamkuli|
         Uninor|9386897706|7488049301|9122112522|NULL 
 TT0000013101724|
         MCSLOOSLOOB001|Jul  3 2012 11:18AM|
         MAHARASHTRA + GOA|
         SELOO|
         TULIP|9325405402|9325406984|9953194983|NULL

But I want O/P in one line. Kindly suggest a query.

---------- Post updated at 01:25 AM ---------- Previous update was at 01:14 AM ----------

Ok...But plz reply now for my query

---------- Post updated at 01:25 AM ---------- Previous update was at 01:25 AM ----------

Ok...But plz reply now for my query

2

Hi

$ cat file
TT0000013101640|
         HCAMBLAMCNB010|Jul  3 2012 11:14AM|
         HARYANA|
         Bangali Mohalla |
         TCL-UBR|9368040005|9355264655|9218509220|NULL
 TT0000013101695|
         QCKNKEKKUIB001|Jul  3 2012 11:17AM|
         JHARKHAND|
         Kathkamkuli|
         Uninor|9386897706|7488049301|9122112522|NULL
 TT0000013101724|
         MCSLOOSLOOB001|Jul  3 2012 11:18AM|
         MAHARASHTRA + GOA|
         SELOO|
         TULIP|9325405402|9325406984|9953194983|NULL

$ sed 's/^ *//' file | awk '/\|$/{printf $0;next}1'
TT0000013101640|HCAMBLAMCNB010|Jul  3 2012 11:14AM|HARYANA|Bangali Mohalla |TCL-UBR|9368040005|9355264655|9218509220|NULL
TT0000013101695|QCKNKEKKUIB001|Jul  3 2012 11:17AM|JHARKHAND|Kathkamkuli|Uninor|9386897706|7488049301|9122112522|NULL
TT0000013101724|MCSLOOSLOOB001|Jul  3 2012 11:18AM|MAHARASHTRA + GOA|SELOO|TULIP|9325405402|9325406984|9953194983|NULL
3

One more way .. (Based on the input given)

$ nawk '{$1=$1};1' infile | paste -d" " - - - - -
TT0000013101640| HCAMBLAMCNB010|Jul 3 2012 11:14AM| HARYANA| Bangali Mohalla | TCL-UBR|9368040005|9355264655|9218509220|NULL
TT0000013101695| QCKNKEKKUIB001|Jul 3 2012 11:17AM| JHARKHAND| Kathkamkuli| Uninor|9386897706|7488049301|9122112522|NULL
TT0000013101724| MCSLOOSLOOB001|Jul 3 2012 11:18AM| MAHARASHTRA + GOA| SELOO| TULIP|9325405402|9325406984|9953194983|NULL
$
4

Thanks alot for the reply.

I tried sed 's/^ *//' temp | awk '/\|$/{printf $0;next}1' its giving me error .
awk: syntax error near line 1
awk: bailing out near line 1

Plz help to get out of this

5

Use nawk for Solaris machines ..

6

Hi
If your OS is solaris, in place of awk, use nawk, else use /usr/xpg4/bin/awk