Approach for Arrays

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Approach for Arrays

Logged in as: Guest

arrSession:exec spGetSession 2,2,59013

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Approach for Arrays
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Approach for Arrays - 4/11/2008 2:11:56 AM

shahid09

Posts: 58
Score: 0
Joined: 1/22/2007
Status: offline

Hi All,

I am trying to capture values from HTML Webtable. To capture Webtable I am creating so many Arrays. Is there any way I can make this code more efficient ? Like destory array and recreate.

Dim TableOCD(3),TableOCD1(3),TableOCD2(3),TableOCD3(3),TableOCD4(3),TableOCD5(3),TableOCD6(3),TableOCD7(3),TableOCD8(3)
   
Set objTable = Browser("B").Page("P").Webtable("W") 
 For OCD = 1 to 3
  TableOCD(OCD)=  objTable.object.rows(OCD).cells(1).outertext 
  msgbox TableOCD(OCD)
  TableOCD1(OCD) = objTable.object.rows(OCD).cells(2).outertext
  msgbox TableOCD1(OCD)
  TableOCD2(OCD) =  TableOCD(OCD) & " " & TableOCD1(OCD)
 Msgbox  TableOCD2(OCD)
 Next
     msgbox join(TableOCD2)

For OCD1 = 1 to 3
  TableOCD3(OCD1)=  objTable.object.rows(OCD1).cells(5).outertext 
  msgbox TableOCD3(OCD1)
  TableOCD4(OCD1) = objTable.object.rows(OCD1).cells(6).outertext
  msgbox TableOCD4(OCD1)
  TableOCD5(OCD1) =  TableOCD3(OCD1) & " " & TableOCD4(OCD1)
 Msgbox  TableOCD5(OCD1)
 Next
     msgbox join(TableOCD5)

For OCD2 = 1 to 2
  TableOCD6(OCD2)=  objTable.object.rows(OCD2).cells(9).outertext 
  msgbox TableOCD6(OCD2)
  TableOCD7(OCD2) = objTable.object.rows(OCD2).cells(10).outertext
  msgbox TableOCD7(OCD2)
  TableOCD8(OCD2) =  TableOCD6(OCD2) & " " & TableOCD7(OCD2)
 Msgbox  TableOCD8(OCD2)
 Next
     msgbox join(TableOCD8)
End Sub

This is the Webtbale Which I want to capture

Here 43820 is a combination of Colum 1 and Column 3 , the value of 9 is cobmination coulmn 5 and 6 and value of 17 is combination of colum 9 and 10

Other Codes

1. 43820       9.            17.
2.  4019        10.           18.
3. 53081      11.           19.
4. 7812        12.           20.
5. 7872        13.           21.
6.                  14.           22.
7.                  15.           23.

Thanks in advance,
SK

_____________________________

shahid

Post #: 1

RE: Approach for Arrays - 4/11/2008 2:41:18 AM

TNO

Posts: 1247
Score: 10
Joined: 12/18/2004
From: thenewobjective.com
Status: offline

Could you post your HTML table? I could think better looking at the raw data.

_____________________________

To iterate is human, to recurse divine. -- L. Peter Deutsch

(in reply to shahid09)

Post #: 2

RE: Approach for Arrays - 4/11/2008 3:12:21 AM

shahid09

Posts: 58
Score: 0
Joined: 1/22/2007
Status: offline

<table border="0" width="100%" cellpadding=0 cellspacing=2>
             <tr>
              <td width="50%">
               <table width="100%" bgcolor="#ffffcc" border=0 cellpadding=0 cellspacing=0>
                <tr>
                 <Td colspan=11><div class="claimbold8">Occurrence Codes & Dates</div></td>
                </tr> 
                
                <tr>
                 <td WIDTH="5%"><div class="blackbold8">1.&nbsp;</div></td>                  
                 <td WIDTH="8%"><div class="black8">70&nbsp;</div></td>                 
                 <td WIDTH="18%"><div class="black8">08/05/2007&nbsp;</div></td>  
                 <td WIDTH="2%"><div class="black8">&nbsp;</div></td>  
                 <td WIDTH="5%"><div class="blackbold8">4.&nbsp;</div></td>                  
                 <td WIDTH="8%"><div class="black8">&nbsp;</div></td>                 
                 <td WIDTH="18%"><div class="black8">&nbsp;</div></td>                 
                 <td WIDTH="2%"><div class="black8">&nbsp;</div></td>  
                 <td WIDTH="5%"><div class="blackbold8">7.&nbsp;</div></td>                  
                 <td WIDTH="10%"><div class="black8">&nbsp;</div></td>                 
                 <td WIDTH="34%"><div class="black8">&nbsp;</div></td>
                </tr>
                <tr>
                 <td><div class="blackbold8">2.&nbsp;</div></td>                  
                 <td><div class="black8">&nbsp;</div></td>                 
                 <td><div class="black8">&nbsp;</div></td>  
                 <td><div class="black8">&nbsp;</div></td>  
                 <td><div class="blackbold8">5.&nbsp;</div></td>                  
                 <td><div class="black8">&nbsp;</div></td>                 
                 <td><div class="black8">&nbsp;</div></td>                 
                 <td><div class="black8">&nbsp;</div></td>  
                 <td><div class="blackbold8">8.&nbsp;</div></td>                  
                 <td><div class="black8">&nbsp;</div></td>                 
                 <td><div class="black8">&nbsp;</div></td>
                </tr>  
                <tr>
                 <td><div class="blackbold8">3.&nbsp;</div></td>                  
                 <td><div class="black8">&nbsp;</div></td>                 
                 <td><div class="black8">&nbsp;</div></td>  
                 <td><div class="black8">&nbsp;</div></td>  
                 <td><div class="blackbold8">6.&nbsp;</div></td>                  
                 <td><div class="black8">&nbsp;</div></td>                 
                 <td><div class="black8">&nbsp;</div></td>                 
                 <td><div class="black8">&nbsp;</div></td>  
                </tr>                             
               </table>
              </td>
             </tr>
              </table>
            </td>
             </tr>
            
           </table>
          </td>
        </tr>
                         </table>

(in reply to TNO)

Post #: 3

RE: Approach for Arrays - 4/11/2008 4:04:12 AM

TNO

Posts: 1247
Score: 10
Joined: 12/18/2004
From: thenewobjective.com
Status: offline

Ouch. No wonder you're having a hard time. You have at least 2 nested tables (and the ending tags of two more...) not to mention alot of attribute pollution and hard-coded spacing using & nbsp;.

Honestly the table format needs to be rewritten badly so you don't have a heart attack trying to parse it with your code. Are you able to do this? or are you trying to read this data from someone else's table? If its your table, I'll rewrite the format for you so its alot easier to look at, alot smaller and easier to parse. Otherwise I'll start playing with your code. Depending on which portions of the code you have access to edit will determine the solution

< Message edited by TNO -- 4/11/2008 4:27:33 AM >

_____________________________

To iterate is human, to recurse divine. -- L. Peter Deutsch

(in reply to shahid09)

Post #: 4

RE: Approach for Arrays - 4/11/2008 5:18:15 AM

shahid09

Posts: 58
Score: 0
Joined: 1/22/2007
Status: offline

TNO.

Thanks for your reply. Actually this is not my code and even i can't access this code. I just right clicked on application and send you the source code. I am a automation engineer and just trying to retrive these value from the table. You don't really need to write anything. Thanks for your help. I just gave a try if anyone can help me to parse it.

Thanks,
SIK

(in reply to TNO)

Post #: 5

RE: Approach for Arrays - 4/11/2008 6:45:03 AM

TNO

Posts: 1247
Score: 10
Joined: 12/18/2004
From: thenewobjective.com
Status: offline

Ok then. Maybe this will give you a place to start. Since I don't know the details of the page layout, you may have to do some more work inside of the For Loop to get rid of extraneous results

_____________________________

To iterate is human, to recurse divine. -- L. Peter Deutsch

(in reply to shahid09)

Post #: 6

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Approach for Arrays

Page: [1]

Jump to:

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts