These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#33424 - 09/27/10 12:51 AM Removing Spaces within a field
Itstaff Offline
OL Newbie

Registered: 07/28/10
Posts: 1
Is there a way to remove blank spaces within two words in a field?

The trim functions only remove leading and trailing spaces but not between words or numbers in one field.


#33425 - 09/27/10 02:34 AM Re: Removing Spaces within a field [Re: Itstaff]
Sander vd Berg Offline
OL Expert

Registered: 06/10/08
Posts: 207
Loc: Objectif Lune NL
If it's just spaces you want to remove you can use REPLACE([Field], " ", "")