Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
Shopmotion


Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search
Affiliates
free forum
 
September 2018
MonTueWedThuFriSatSun
     12
3456789
10111213141516
17181920212223
24252627282930

Calendar Calendar


Removing Extra Spaces

Go down

Removing Extra Spaces

Post  reena on Wed Mar 19, 2008 2:53 am

Hi. I'm looking for the easiest way to remove double spaces in a field. I have many addresses where there is and extra space between the name of the street and the suffix. For example, "110 MAIN (extra space here) ST" when it should be "110 MAIN ST". Does anybody know a quick way to clean this up?

reena

Posts : 6
Join date : 2008-03-16

View user profile

Back to top Go down

Re: Removing Extra Spaces

Post  glenn on Wed Mar 19, 2008 2:57 am

did you try
Replace([yourfield], " ", " ")
on a backup of course

glenn

Posts : 11
Join date : 2008-03-17

View user profile

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum