Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
Shopmotion


Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search
Affiliates
free forum
 
April 2018
MonTueWedThuFriSatSun
      1
2345678
9101112131415
16171819202122
23242526272829
30      

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