Globe GIS
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Remote sensing is the acquisition of information of an object or phenomenon, by the use of either recording or real-time sensing devices that is not in physical or intimate contact with the object.

Search
 
 

Display results as :
 

Rechercher Advanced Search

Latest topics
» GIS training centers in Bangalore
Removing Extra Spaces EmptyThu Jul 28, 2011 11:51 pm by Ronney

» Chicago Festival of maps continues
Removing Extra Spaces EmptySat Dec 26, 2009 9:53 am by victoria justice

» Province of BC unlocks digital data and strikes a deal with Google
Removing Extra Spaces EmptySat Dec 26, 2009 9:47 am by victoria justice

» share GPS tracks via Google Earth
Removing Extra Spaces EmptySat Dec 26, 2009 9:45 am by victoria justice

» GIS for Web Developers: Adding ‘Where’ to Your Web Applications
Removing Extra Spaces EmptySat Mar 14, 2009 1:34 am by prabhakar

» How to Design a GIS Project
Removing Extra Spaces EmptyThu Dec 25, 2008 4:37 am by sean flynn

» ArcGIS Desktop 9.3: New KML Export Support
Removing Extra Spaces EmptyThu Dec 25, 2008 4:34 am by sean flynn

» ArcGIS 9.3: ESRI Resource Centers
Removing Extra Spaces EmptyThu Dec 25, 2008 4:25 am by sean flynn

» Help for interview..urgent
Removing Extra Spaces EmptyWed Aug 27, 2008 3:28 am by ironore

Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search
Forum
Affiliates
free forum
 
May 2024
MonTueWedThuFriSatSun
  12345
6789101112
13141516171819
20212223242526
2728293031  

Calendar Calendar


Removing Extra Spaces

2 posters

Globe GIS :: Tutorials :: For GIS software

Go down

Removing Extra Spaces Empty Removing Extra Spaces

Post  reena 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

Back to top Go down

Removing Extra Spaces Empty Re: Removing Extra Spaces

Post  glenn 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

Back to top Go down

Back to top

Globe GIS :: Tutorials :: For GIS software

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