We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

help with loop

cdb424ttm
cdb424ttm asked
on
Medium Priority
207 Views
Last Modified: 2010-05-01
I wrote this code to pull the first borr_nrb which (is 1). And the first instance of  brr-nbr (one). Once it is found I want it to fine borr_nbr (2) and give me the first instance of borr_nbr 2. I need help is setting up the loop or counter.
Thanks

Dim Result
Dim intIndex As integer
Dim strAddr As string

For intIndex = 1 To Val(CDE.LT-ADDRESS.BORR-ADDR("Count"))
      If Val(CDE.LT-ADDRESS.BORR-NBR(intIndex)) = vElementIndex Then
            strAddr = Trim(CDE.LT-ADDRESS.BORR-ADDR(intIndex))
            If Trim(CDE.LT-ADDRESS.BORR-ADDR2(intIndex)) <> "" Then
                  strAddr = strAddr & ", " & Trim(CDE.LT-ADDRESS.BORR-ADDR2(intIndex))
            End If
            If CDE.LT-ADDRESS.MILIT-FLAG(intIndex) = True Then
                  If Trim(CDE.LT-ADDRESS.MILIT-ADDR(intIndex)) <> "" Then
                        strAddr = strAddr & ", " & Trim(CDE.LT-ADDRESS.MILIT-ADDR(intIndex))
                  End If
            Else
                  If Trim(CDE.LT-ADDRESS.BORR-CITY(intIndex)) <> "" Then
                        strAddr = strAddr & ", " & Trim(CDE.LT-ADDRESS.BORR-CITY(intIndex))
                  End If
                  If Trim(CDE.LT-ADDRESS.BORR-ST(intIndex)) <> "" Then
                        strAddr = strAddr & ", " & Trim(CDE.LT-ADDRESS.BORR-ST(intIndex))
                  End If
                  If Trim(CDE.LT-ADDRESS.BORR-ZIP(intIndex)) <> "" Then
                        strAddr = strAddr & "  "
                        If Len(Trim(CDE.LT-ADDRESS.BORR-ZIP(intIndex))) = 9 Then
                              strAddr = strAddr & LEFT(Trim(CDE.LT-ADDRESS.BORR-ZIP(intIndex)), 5) & "-"
                              strAddr = strAddr & RIGHT(Trim(CDE.LT-ADDRESS.BORR-ZIP(intIndex)), 4)
                        Else
                              strAddr = strAddr & Trim(CDE.LT-ADDRESS.BORR-ZIP(intIndex))
                        End If
                  End If
            End If
            Exit For
      End If
Next
Comment
Watch Question

Retired
CERTIFIED EXPERT
Top Expert 2012
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.