Determining the highest array value without cycling through

[Jozef]

Hello,

Is there an easy way to determine the highest point in an array that
contains a value? I'm dimensioning an array to hold up to 255 items, but if
it only contains three, I don't want to cycle through all 255 if that's
possible.

any ideas?
Thanks!

[John Mishefske]

Jozef wrote:

Hello,

Is there an easy way to determine the highest point in an array that
contains a value? I'm dimensioning an array to hold up to 255 items, but if
it only contains three, I don't want to cycle through all 255 if that's
possible.

Yes, you could create a separate counter variable to let you know how may of the array
slots are populated. Or you could use a marker in the slot after the last valid entry.

You could also dynamically resize the array using the Redim statement but there may be
performance issues to consider.

--
'---------------
'John Mishefske
'---------------

[rkc]

Jozef wrote:

Hello,

Is there an easy way to determine the highest point in an array that
contains a value?
Not unless you were keeping track while the array was being
populated.
I'm dimensioning an array to hold up to 255 items, but if
it only contains three, I don't want to cycle through all 255 if
that's possible.

It's possible to check for a value and exit the loop if there isn't
one. Something you should be doing any way if you're performing
some operation on each value as you cycle through them.

[lylefair]

My idea (for a string array, a) is

UBound(Split(RT rim(Join(a))))

Please, let me know how and if this works as it's "total air" code.

[Thelma Lubkin]

ly******@yahoo. ca <ly******@yahoo .ca> wrote:
: My idea (for a string array, a) is

: UBound(Split(RT rim(Join(a))))

: Please, let me know how and if this works as it's "total air" code.
Does this mean that this is invalid?

Dim Aray(26) as String
Aray(19) = "This "
Aray(8) = "is "
Aray(12) = "my "
Aray(0) = "array."

This 26 element array with four defined elements has its last
defined element at place 20
A separate counter seems like the safest route to me, updated like
this:

If array_position_ just_defined > highest_array_p osition Then
highest_array_p osition = array_position_ just_defined

with highest_array_p osition initialized to -1 for the empty array.

--thelma

[rkc]

ly******@yahoo. ca wrote:

My idea (for a string array, a) is

UBound(Split(RT rim(Join(a))))

Well I'll be dipped in pancake batter.

[Thelma Lubkin]

Thelma Lubkin <th****@alpha2. csd.uwm.edu> wrote:
: Dim Aray(26) as String
: Aray(19) = "This "
: Aray(8) = "is "
: Aray(12) = "my "
: Aray(0) = "array."

: This 26 element array with four defined elements has its last
: defined element at place 20

arghh... 19
--thelma

: A separate counter seems like the safest route to me, updated like
: this:

: If array_position_ just_defined > highest_array_p osition Then
: highest_array_p osition = array_position_ just_defined

: with highest_array_p osition initialized to -1 for the empty array.

[David W. Fenton]

"Jozef" <SP**********@t elus.net> wrote in
news:w1Lue.1786 745$6l.247118@p d7tw2no:

Is there an easy way to determine the highest point in an array
that contains a value? I'm dimensioning an array to hold up to
255 items, but if it only contains three, I don't want to cycle
through all 255 if that's possible.

Why do you have blank entries in your array?

If you need to have a certain number of parameters with or without
values, what about using the array in conjunction with a collection,
and you'd use the collection to manage which items had values?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[lylefair]

Thelma Lubkin wrote:

Thelma Lubkin <th****@alpha2. csd.uwm.edu> wrote:
: Dim Aray(26) as String
: Aray(19) = "This "
: Aray(8) = "is "
: Aray(12) = "my "
: Aray(0) = "array."

: This 26 element array with four defined elements has its last
: defined element at place 20

arghh... 19
--thelma

Huh?

[Jozef]

Thanks for your help folks. I'm already using a counter, I was just curious
if there was a single function I could call (there should be,
Microsoft...are you listening?) Something like MaxArr(MyArray) ....tha'd be
good.
"Jozef" <SP**********@t elus.net> wrote in message
news:w1Lue.1786 745$6l.247118@p d7tw2no...

Hello,

Is there an easy way to determine the highest point in an array that
contains a value? I'm dimensioning an array to hold up to 255 items, but
if it only contains three, I don't want to cycle through all 255 if that's
possible.

any ideas?
Thanks!