Address Issues for Geocoding

[Sea, Carleton, VBAVACO]

Hi All,

I have a variable called Address1 which gives the entire number and street address.  Some some unknown reason, the data file has been corrupted and now has the street number and the name running into one another:

(i.e., 123Round Table Drive, 5228West Voltaire Drive, etc). 

Need to change to 123 Round… & 5228 West, etc.

I need to add a space after the last number so I can geocode the address to a map. 

Any assistance would be greatly appreciated.  Thanks.

V/r,

Carleton Sea

[David Marso]

"Some some unknown reason, the data file has been corrupted "...
Hmmmm, the computer ate your spaces?
More likely somebody upstream f'd up.  You might want to examine your processes?
--
DATA LIST /ADDR (A50).
BEGIN DATA.
123Round Table Drive
5228West Voltaire Drive.  
END DATA.
STRING ADDRFIX (A50).
COMPUTE #LAST=CHAR.RINDEX(ADDR,"0123456789",1).
COMPUTE ADDRFIX=CONCAT(CHAR.SUBSTR(ADDR,1,#LAST)," ",CHAR.SUBSTR(ADDR,#LAST+1)).
LIST.


ADDR                                               ADDRFIX

123Round Table Drive                               123 Round Table Drive
5228West Voltaire Drive.                           5228 West Voltaire Drive.


Number of cases read:  2    Number of cases listed:  2

Sea, Carleton, VBAVACO wrote

Hi All,

I have a variable called Address1 which gives the entire number and
street address.  Some some unknown reason, the data file has been
corrupted and now has the street number and the name running into one
another:

(i.e., 123Round Table Drive, 5228West Voltaire Drive, etc).  

Need to change to 123 Round... & 5228 West, etc.

I need to add a space after the last number so I can geocode the address
to a map.  

Any assistance would be greatly appreciated.  Thanks.

V/r,


> Carleton Sea
>