Break up a field

  • Thread starter Thread starter vjp2.at
  • Start date Start date
V

vjp2.at

I want to break up (tokenise) a field by where the hypens and spaces
are in order to make comparisons.

Longer story: STRADR typicall looks like "crosstreet-bldgnumber
streetname streetype". I want to look at old.stradr and if new.stradr
has the same crosstreet and streetname, and the same odd/even status
of bldgnumber, I want to also assign old.ziplus4 to new.ziplus4

Suggestions?

- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://ourworld.compuserve.com/homepages/vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos]
 
Use Split() to break up the string into an array of individual words.

Since you need to break on hypens as well as spaces, use Replace() to
replace the hypens with spaces before you Split it.
 
Back
Top