Removing Spaces within a field - Objectif Lune Tech Support Self Help

IMPORTANT ANNOUNCEMENT

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)

You are not logged in. [Log In] Objectif Lune » Forums » PrintShop Mail Suite 7 » PrintShop Mail Design » Removing Spaces within a field

Topic Options

#33424 - 09/27/10 12:51 AM Removing Spaces within a field
Itstaff 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. Thanks
Top

#33425 - 09/27/10 02:34 AM Re: Removing Spaces within a field [Re: Itstaff]
Sander vd Berg 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], " ", "")
Top

Previous Topic

Index

Next Topic

Hop to:

Moderator: Alex Banahene, cosimo, Jean-Cédric, OL Newsgroup Support, OL Newsgroup Training, Philippe F., Raphael Lalonde Lefebvre