FN-FORUM: Array search

date posted 17th January 2006 20:31

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).