Re: FN-FORUM: Array search

date posted 17th January 2006 21:12

Oops, just re-read your mail and realised you know why it' s not
working. Ignore my last mail.

Adam

On 17 Jan 2006, at 21:04, David J MacKillican wrote:

>
> Hi
>
> I am searching an array, after googling furiously, and have got it
> working
> lovely, apart from one thing. The array has numbers like 1, 2, 3
> and 102,
> 103, and 104. the problem is the search decides that 10 is in there
> too.
>
> Any ideas, nothing on Google and I cannot find a vb function that
> ensures it
> only gets the complete number.
>
> Code doing the search is;
>
> SearchArray = UBound(Filter(arrArray, strValuetoSearch, True, 0)) > -1
>
> VbScript
>
> The result is showing true, which in one sense it is, but still not
> right.
>
> Any ideas?
>
> David J MacKillican
> http://www.djmwebservices.com your business open 24 hours
>
> Telephone: 01249 701194
> Mobile: 07973194834
> Facsimile: 01249 713501
>
> The information contained in or attached to this email is intended
> only for
> the use of the individual or entity to which it is addressed. If
> you are not
> the intended recipient, or a person responsible for delivering it
> to the
> intended recipient, you are not authorised to and must not
> disclose, copy,
> distribute, or retain this message or any part of it. It may contain
> information which is confidential and/or covered by legal
> professional or
> other privilege (or other rules or laws with similar effect in
> jurisdictions
> outside England and Wales).
>
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>