September 27th, 2012, 02:51 PM
|
|
Registered User
|
|
Join Date: Sep 2012
Posts: 1
Time spent in forums: 10 m 58 sec
Reputation Power: 0
|
|
|
Move data based on specific text in an address field into a different column
I have a database that contains address 1 and address 2 data. In doing some data validation with USPS software, the Ste X/Floor/Bldg. information needs to be in the address 2 field. There are more than 3000 records that have the information combined.
How can programmatically strip the Ste X data from the address 1 field and put it into the address 2 field?
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
