How about:
1) use StringTokenizer to break the string into tokens (i.e., 2-letter state
Strings)
2) put each token into a HashSet
3) query for membership using set.contains("CA");
DR
On Wednesday 26 March 2003 01:31 pm, Greg Nudelman wrote:
> I have a DB field of user-entered 2-letter states, separated by a comma.
>
>
> states = "CA, OR, TX";
>
> or it could be
>
> states = " CA,OR,TX, HI ";
>
> in other words, spacing is inconsistent, but case seems to be OK.
>
> I need to relaibly and FAST! answer:
>
> is state = "CA" in states
>
> Any ideas?
>
> Greg
>
> ----------------------------------------------
>
> P.S. this is what we got so far:
>
> 1) run a perl script on DB that will remove the extra spacing
> 2) add the flanking commas to both:
>
> state = ",CA,";
> states = ",CA,OR,TX,HI,";
>
> 3) states.indexOf(state) != -1
>
> Greg
>
> ---
> You are currently subscribed to jdjlist as:
> [EMAIL PROTECTED]
> To unsubscribe send a blank email to
> [EMAIL PROTECTED]
> http://www.sys-con.com/fusetalk
---
You are currently subscribed to jdjlist as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
http://www.sys-con.com/fusetalk
