Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
Shopmotion


Removing Extra Spaces Empty
Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search
Affiliates
free forum
 
April 2019
MonTueWedThuFriSatSun
1234567
891011121314
15161718192021
22232425262728
2930     

Calendar Calendar


Removing Extra Spaces

Go down

Removing Extra Spaces Empty 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

Removing Extra Spaces Empty 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

- Similar topics

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