How to remove the spaces in a field

[Woodyuk]

Im writing a report, and need to do something very simple but I cant seem to do it. I have a field which contains postcodes. This is just numbers and letters like "WD24 1AB" or "HP2 4JK". All I want to do is get rid of the spaces in the fields ie "WD24 1AB" to "WD241AB" or "HP2 4JK" to "HP2 4JK"

It sounds simple to me or am I asking for too much?

Also some of the data has been enter in wrong, ie more than one space etc

Im using Crystal 10

 

[lbass]

Use:

replace({table.field}," ","")

-LB

 

[Woodyuk]

Once again you have come up tops lbass.

Many thanks