Re: count array element in word vba

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Alex Ivanov (consul_at_collegeclub.com)
Date: 03/03/04 

Date: Wed, 3 Mar 2004 15:23:38 -0800

ubound(arrAircraft)?

"scott" <scott@sporticia.com> wrote in message
news:uX37k8WAEHA.740@TK2MSFTNGP12.phx.gbl...
> hi
>
> I have a snippet of code that take a given string and uses 'split' to pop
it
> into an array for me
>
> the string is being split with the space char as the seperator
>
> the problem is that sometimes the string will contain x2 words, other
times
> x3 or x4
>
> is there a way to count or return the number of array elements being
created
> from the split ?
>
> code below
>
> <snip>
> 'need to split aircraft names up for displayy purposes
> strAircraft = Trim(AirCraftBox.Value)
> arrAircraft = Split(strAircraft)
>
> 'most planes have 3 part names
> If Count.arrAircraft() > 2 Then
> strAircraft_Make = arrAircraft(0)
> strAircraft_Model = arrAircraft(1) & " " &
> arrAircraft(2)
> 'gulfs have 2 part names only
> Else
> strAircraft_Make = arrAircraft(0) & " " &
> arrAircraft(1)
> End If
> </snip>
>
> obviously this is not working, is there a method for dealing with this ?
or
> will I have to loop through all elements to determin how many there are
> (seems a little inefficient that way round !)
>
> thanks
>
> _scott
>
>

Relevant Pages

  • Help in French|Spanish|German translation.
    ... I am also an author of User-defined string functions. ... WORDTRANEX (cSearched, cArExpressionSought | cExpressionSough, ... each string of the array is searched ... If the parameter nArStartOccurrence is -1 or omitted, the replacement starts ...
    (microsoft.public.fox.helpwanted)
  • Re: passing a string to a dll
    ... Joe, I really appreciate you taking the time to demonstrate this. ... sure how I would implement indexing it for random alphanumeric codes. ... I might handle the array. ... I actually have been wondering if I could use a second string ...
    (microsoft.public.vc.mfc)
  • Re: passing a string to a dll
    ... I might handle the array. ... I actually have been wondering if I could use a second string ... look at insertion cost, organization cost, and search cost. ...
    (microsoft.public.vc.mfc)
  • RE: Structure conversion from C++ to VB-2008?
    ... One of the most important structures is AmiVar structure. ... point number, the array of floating point numbers, a string or IDispatch ... Dim 13012679 as Integer ...
    (microsoft.public.dotnet.languages.vb)
  • Structure conversion from C++ to VB-2008?
    ... One of the most important structures is AmiVar structure. ... point number, the array of floating point numbers, a string or IDispatch ... Dim 13012679 as Integer ...
    (microsoft.public.dotnet.languages.vb)