Remove excess spaces from file 1

[ianicr]

Hi. I've got a file with UK postcode sectors in it eg.

AL 1 1
B 1 3
CH12 4
DE 3 5
and I need to remove all the spaces in the file before the last one to make the file:

AL1 1
B1 3
CH12 4
DE3 5

Does anyone know an easy way to do this?

Thanks

 

[CaKiwi]

The following awk script is one way.

{
a=""
for (j=1;j<NF;j++) a=a $j
print a,$NF
}

CaKiwi

 

[ianicr]

If I could give you more stars I would!!! thanks a lot!!