Solved

Extract data from html <td> tags using vb6

Posted on 2014-11-24
16
194 Views
Last Modified: 2014-11-25
Hello,

Could you please help with a solution to extract specific data between repeating <td> tags? I have attached the input file for review. Here is an example of what I want:
From the code below, I want to extract the text (without the quotes)  - "http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html"

I tried a different approach - reading the text file line by line and parsing each line for "href" and "title" combo but was not exactly successful. So, I'd appreciate a solution in stead of a reference as I have already wasted several hours looking for a possible solution. Thanks!

<td class="topicsName" style="width:100%">
<a class="newestPostIcon" href="http://gmatclub.com/forum/viewtopic.php?f=140&amp;t=41301&amp;view=unread&amp;sid=e529503533ca87ee136c986f3c5d6e66#unread"><img src="./styles/gmatclub_light/imageset/icon_topic_newest.png" width="18" height="10" alt="View first unread post" title="View first unread post" /></a>
<a href="http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html" title="If |d - 9| = 2d, then d= (A) -9 (B) -3 (C) 1 (D) 3 (E) 9" >
<span class="topicTitle">If |d-9| = 2d, then d=</span>
</a>
&nbsp;
<p> 
Tags:&nbsp;<a href="./search.php?search_id=tag&tag_id=217&amp;sid=e529503533ca87ee136c986f3c5d6e66">Difficulty: Sub-600 Level</a>, &nbsp;<a href="./search.php?search_id=tag&tag_id=58&amp;sid=e529503533ca87ee136c986f3c5d6e66">Absolute Values/Modules</a>																					</p>
<p>in <a href="http://gmatclub.com/forum/gmat-problem-solving-ps-140/">GMAT Problem Solving (PS)</a></p>
</td>

Open in new window

PageHTML.txt
0
Comment
Question by:Jay Balu
  • 7
  • 7
16 Comments
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
From the HTML snippet you posted, what text do you need to parse
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
rivate Sub Form_Load()
Dim fso As New FileSystemObject
Dim f As File
Dim fsoStream As TextStream
Dim strLine As String
Dim intPos As Integer

Set f = fso.GetFile("C:\temp\PageHTML.txt")
Set fsoStream = f.OpenAsTextStream(ForReading)

Do While Not fsoStream.AtEndOfStream
    strLine = fsoStream.ReadLine
    If strLine <> "" Then
        intPos = InStr(1, strLine, "http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html")
        If intPos > 0 Then
            Debug.Print Mid$(strLine, intPos, Len("http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html"))
       End If
    End If
Loop

fsoStream.Close
Set fsoStream = Nothing
Set f = Nothing
Set fso = Nothing

End Sub

Open in new window

0
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
From the linked page you provided there seems to be this data:
URL: /forum/?fl=menu
Title: Forum Index Page

URL: http://gmatclub.com/forum/viewtopic.php?f=140&t=41301&start=0&&st=0&sk=t&sd=a&view=print
Title: Print view

URL: http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html#p287403
Title: Post

URL: http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html#p287480
Title: Post

URL: http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html#p287711
Title: Post

URL: http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html#p287759
Title: Post

URL: http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html#p287792
Title: Post

URL: http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html#p627900
Title: Post

URL: http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html#p856970
Title: Post

URL: /forum/premium
Title: Premium Member

URL: /tests
Title: CAT Tests

URL: http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html#p856980
Title: Post

URL: /forum/premium
Title: Premium Member

URL: http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html#p1273241
Title: Post

URL: /forum/premium
Title: Premium Member

URL: http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html#p1431654
Title: Post

URL: /forum/gmat-club-member-benefits-in-detail-120889.html
Title: one thing you wish you knew about GMAT

URL: http://gmatclub.com/
Title: GMAT Club MBA Forum Home

URL: http://www.phpbb.com/
Title: Search Engine Optimization

Open in new window

0
 

Author Comment

by:Jay Balu
Comment Utility
Martin and Aikimark,

My sorry for the confusion. What I want is not just "http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html". I want all of such links enclosed in the repeating <td  class="topicsName">s in the attached file. I just gave an example of what the data I want to extract looks like. Again, in the attached file, you would see about 39-40 such <td  class="topicsName">s with each hyperlink pointing to a different resource. I just want to extract the hyperlinks (href data). Also, since this code will be run against multiple html files (just like the one attached), I cannot have a hard coded looper (e.g. 39-40). I hope it made sense. Please let me know if you have any follow up questions.
0
 

Author Comment

by:Jay Balu
Comment Utility
Oh, just to add  - the <a> tag "href" of interest will also have "title=" alongside of it. For e.g. in the example provided above,
<td class="topicsName" style="width:100%">
<a class="newestPostIcon" href="http://gmatclub.com/forum/viewtopic.php?f=140&amp;t=41301&amp;view=unread&amp;sid=e529503533ca87ee136c986f3c5d6e66#unread"><img src="./styles/gmatclub_light/imageset/icon_topic_newest.png" width="18" height="10" alt="View first unread post" title="View first unread post" /></a>
<a href="http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html" title="If |d - 9| = 2d, then d= (A) -9 (B) -3 (C) 1 (D) 3 (E) 9" >
<span class="topicTitle">If |d-9| = 2d, then d=</span>
</a>
&nbsp;
<p> 
Tags:&nbsp;<a href="./search.php?search_id=tag&tag_id=217&amp;sid=e529503533ca87ee136c986f3c5d6e66">Difficulty: Sub-600 Level</a>, &nbsp;<a href="./search.php?search_id=tag&tag_id=58&amp;sid=e529503533ca87ee136c986f3c5d6e66">Absolute Values/Modules</a>																					</p>
<p>in <a href="http://gmatclub.com/forum/gmat-problem-solving-ps-140/">GMAT Problem Solving (PS)</a></p>
</td>

Open in new window


This particular <td class="topicsName> has  multiple <a> tags. The one that I want extracted has "title" with it. I want href of the following pattern ONLY

<a href="http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html" title="If |d - 9| = 2d, then d= (A) -9 (B) -3 (C) 1 (D) 3 (E) 9" >

Open in new window

0
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
Here are all the URL and Title combinations inside <td></td> tags
URL: /forum/?fl=menu
Title: Forum Index Page

URL: http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html
Title: If |d - 9| = 2d, then d= (A) -9 (B) -3 (C) 1 (D) 3 (E) 9

URL: http://gmatclub.com/forum/if-x-y-x-y-and-xy-does-not-equal-0-which-of-the-followin-186803.html
Title: Tough and Tricky questions: Absolute Values. If |x | + |y | = -x – y and xy does not equal 0, which of the following must be true? A. x + y 0 B. x + y 0 C. x – y 0 D. x – y 0 E. x^2 – y^2 0

URL: http://gmatclub.com/forum/if-a-1-3-and-b-2-3-which-of-the-following-cannot-be-the-resul-186802.html
Title: Tough and Tricky questions: Absolute Values. If |a| = 1/3 and |b| = 2/3, which of the following CANNOT be the result of a + b? A. -1 B. -1/3 C. 1/3 D. 2/3 E. 1

URL: http://gmatclub.com/forum/if-x-0-then-root-x-2-x-64138.html
Title: If x\neq{0} , then \frac{ x^2 }{x}= A. -1 B. 0 C. 1 D. x E. \frac{|x|}{x} OPEN DISCUSSION OF THIS QUESTION IS HERE: if-x-0-then-root-x-2-x-87970.html 

URL: http://gmatclub.com/forum/a-b-which-of-the-following-must-be-true-141468.html
Title: |a|=|b|, which of the following must be true : I. a=b II. |a|=-b III. -a=-b A. I only B. II only. C. III only. D. I and III only. E. None

URL: http://gmatclub.com/forum/if-x-and-y-are-integers-such-that-x-1-2-less-than-equal-to-97992.html
Title: If x and y are integers such that (x+1)^2 less than equal to 36 and (y-1)^2 less than 64. What is the largest possible and minimum possible value of xy. In equalities how to handle an expression which is squared Does the above equation (x+1)^2 = 36 mean |x+1| (+6 or -...

URL: http://gmatclub.com/forum/if-y-y-0-which-of-the-following-must-be-true-131099.html
Title: If y + | y | = 0, which of the following must be true? A. y 0 B. y≥0 C. y 0 D. y≤0 E. y = 0 Why is just E incorrect?

URL: http://gmatclub.com/forum/what-is-the-sum-of-all-roots-of-the-equation-85988.html
Title: What is the sum of all roots of the equation |x + 4|^2 - 10|x + 4| = 24? Please help me find my mistake: Let x+4=y Now we get two cases, Case1: y^2-10y-24=0 Solving we get -2,12 Case2: -y^2+10y-24=0 where we get 6,4

URL: http://gmatclub.com/forum/which-of-the-following-inequalities-has-a-solution-set-that-130666.html
Title: Which of the following inequalities has a solution set that, when graphed on a number line, is a single, finite line segment? A. x=4 B. x^2=4 C. x^3=64 D. |x|=4 E. |x|=4

URL: http://gmatclub.com/forum/how-many-different-values-of-positive-integer-x-for-which-175948.html
Title: How many different values of positive integer x, for which |x+8|x, are there? A. 0 B. 2 C. 3 D. 8 E. 16

URL: http://gmatclub.com/forum/for-what-value-of-x-is-x-3-x-1-x-148561.html
Title: For what value of x, is |x – 3| + |x + 1| + |x| = 10? (A) 0 (B) 3 (C) -3 (D) 4 (E) -2

URL: http://gmatclub.com/forum/if-x-0-then-square-root-of-x-x-is-93776.html
Title: If x0, then -x|x| is: A. -x B. -1 C. 1 D. x E. x 

URL: http://gmatclub.com/forum/which-of-the-following-inequalities-is-an-algebraic-expressi-144267.html
Title: Line.png Which of the following inequalities is an algebraic expression for the shaded part of the number line above? (A) |x| = 3 (B) |x| = 5 (C) |x - 2| = 3 (D) |x - 1| = 4 (E) |x +1| = 4

URL: http://gmatclub.com/forum/is-r-s-110584.html
Title: Is r s ? (1) -r + s 0 (2) r | s | OPEN DISCUSSION OF THIS QUESTION IS HERE: is-r-s-1-r-s-0-2-r-s-126745.html 

URL: http://gmatclub.com/forum/which-of-the-following-inequalities-is-an-algebraic-78417.html
Title: number line.png Which of the following inequalities is an algebraic expression for the shaded part of the number line above? (A) |x| = 3 (B) |x| = 5 (C) |x - 2| = 3 (D) |x - 1| = 4 (E) |x +1| = 4 OPEN DISCUSSION OF THIS QUESTION IS HERE: which-of-the-following-inequalities-is-an...

URL: http://gmatclub.com/forum/if-y-1-2-11-2-which-of-the-following-could-be-a-value-136878.html
Title: If |y- 1/2 | 11/2 , which of the following could be a value of y? (A) -11 (B) -11/2 (C) 11/2 (D) 11 (E) 22 Practice Questions Question: 14 Page: 154 Difficulty: 600 

URL: http://gmatclub.com/forum/if-x-y-and-xy-0-which-of-the-following-must-be-true-164829.html
Title: If |x| = |y| and xy 0, which of the following must be true? A. xy^2 0 B. yx^2 0 C. x + y = 0 D. x/y +1=2 E. 1/x + 1/y = 1/2]

URL: http://gmatclub.com/forum/which-of-the-following-represents-1-x-126845.html
Title: Which of the following represents 1x9? A. |x|3 B. |x+5|4 C. |x-1|9 D. |-5+x|4 E. |3+x|5 How to do this quickly? The way I m doing it ( i.e. solving each statement possibilities ) takes 3-4 min.

URL: http://gmatclub.com/forum/if-x-x-which-of-the-following-must-be-true-169104.html
Title: If |x|=−x, which of the following must be true? A. x≥0 B. x≤0 C. x2x D. x30 E. 2xx

URL: http://gmatclub.com/forum/if-x-0-then-root-x-2-x-87970.html
Title: If x\neq{0} , then \frac{ x^2 }{x}= A. -1 B. 0 C. 1 D. x E. \frac{|x|}{x} 

URL: http://gmatclub.com/forum/what-inequality-represents-the-condition-1-x-94759.html
Title: What inequality represents the condition 1x9? (A) |x|3 (B) |x+5|4 (C) |x-1|9 (D) |-5+x|4 (E) |3+x|5 OPEN DISCUSSION OF THE QUESTION IS HERE: which-of-the-following-represents-1-x-126845.html Solution: 10sec. Traditional 3-steps method is too time-consume technique. First of all w...

URL: http://gmatclub.com/forum/if-x-x-then-which-one-of-the-following-statements-90747.html
Title: If x = - |x| , then which one of the following statements could be true? I. x = 0 II. x 0 III. x 0 (A) None (B) I only (C) III only (D) I and II (E) II and III

URL: http://gmatclub.com/forum/which-of-the-following-inequalities-is-always-true-for-any-142171.html
Title: Which of the following inequalities is always true for any real number 'a' and 'b'? (A) |a + b| = |a| + |b| (B) |a + b| |a| + |b| (C) |a + b| = |a| + |b| (D) |a - b| = |a| - |b| (E) |a - b| |a| - |b|

URL: http://gmatclub.com/forum/if-n-is-a-positive-integer-which-of-the-following-is-a-poss-65782.html
Title: If n is a positive integer, which of the following is a possible value of |56 - 5n| ? A. 7 B. 9 C. 12 D. 15 E. 20

URL: http://gmatclub.com/forum/of-the-five-coordinates-associated-with-points-a-b-c-d-63755.html
Title: http://gmatclub.com/forum/download/file.php?id=18091 Of the five coordinates associated with points A, B, C, D, and E on the number line above, which has the greatest absolute value? (A) A (B) B (C) C (D) D (E) E OPEN DISCUSSION OF THIS QUESTION IS HERE: of-the-five-...

URL: http://gmatclub.com/forum/if-y-is-an-integer-then-the-least-possible-value-of-139867.html
Title: If y is an integer, then the least possible value of |23 - 5y| is (A) 1 (B) 2 (C) 3 (D) 4 (E) 5 Practice Questions Question: 51 Page: 159 Difficulty: 600 

URL: http://gmatclub.com/forum/if-10y-4-7-and-y-1-which-of-the-following-could-be-y-137730.html
Title: If |10y - 4| 7 and y 1, which of the following could be y? A. -0.8 B. -0.1 C. 0.1 D. 0 E. 1

URL: http://gmatclub.com/forum/4-157041.html
Title: |-4| (|-20|-|5|)= ?? A. –100 B. –60 C. 60 D. 75 E. 100 Source: Preparation Material MBA Center

URL: http://gmatclub.com/forum/if-3-3-x-7-what-is-the-product-of-all-the-possible-va-150043.html
Title: If 3|3 – x| = 7, what is the product of all the possible values of x? A. 1/9 B. 1/3 C. 2/3 D. 16/9 E. 32/9

URL: http://gmatclub.com/forum/if-a-b-a-b-then-a-b-must-be-equal-to-135283.html
Title: If |a+b|=|a-b|, then a*b must be equal to: A. 1 B. -1 C. 0 D. 2 E. -2

URL: http://gmatclub.com/forum/of-the-five-coordinates-associated-with-points-a-b-c-d-137537.html
Title: ABCDE.png Of the five coordinates associated with points A, B, C, D, and E on the number line above, which has the greatest absolute value? (A) A (B) B (C) C (D) D (E) E Practice Questions Question: 24 Page: 155 Difficulty: 600 

URL: http://gmatclub.com/forum/if-y-is-an-integer-then-the-least-possible-value-of-132062.html
Title: If y is an integer, then the least possible value of |23 – 5y| is A. 1 B. 2 C. 3 D. 4 E. 5 |23-5y| represents the distance between 23 and 5y on the number line. Now, the distance will be minimized when 5y, which is multiple of 5, is closest to 23. Multiple of 5 which is closest ...

URL: http://gmatclub.com/forum/absolute-value-query-122239.html
Title: What inequality represents the condition 1x9? (A) |x|3 (B) |x+5|4 (C) |x-1|9 (D) |-5+x|4 (E) |3+x|5 OPEN DISCUSSION OF THE QUESTION IS HERE: which-of-the-following-represents-1-x-126845.html TOPIC LOCKED. MODERATOR. The answer to this question is D. I am confused because even C s...

URL: http://gmatclub.com/forum/is-r-s-1-r-s-0-2-r-s-127745.html
Title: Is r s ? (1) -r + s 0 (2) r |s| OA.A is my interpretation of statement 2 wrong? |s|r. so, s-r or sr if sr. r is not greater than s so sufficient if s-r, means r-s. if r is less than -s it cannot be greater than s so sufficient. Answer should be D. Please explain

URL: http://gmatclub.com/forum/modules-109065.html
Title: Q35: If n is a positive integer, which of the following is a possible value of |56 - 5n|? A. 7 B. 9 C. 12 D. 15 E. 20 how we can compute value in this pls help

URL: http://gmatclub.com/forum/of-the-five-coordinates-associated-with-points-a-b-c-d-an-106483.html
Title: http://gmatclub.com/forum/download/file.php?id=13663 Of the five coordinates associated with points A, B, C, D and E on the number line above, which has the greatest absolute value? A. A B. B C. C D. D E. E

URL: http://gmatclub.com/forum/if-y-y-0-which-of-the-following-must-be-true-93878.html
Title: If y + |y| = 0 which of the following must be true? A. y 0 B. y = 0 C. y 0 D. y = 0 E. y = 0

URL: http://gmatclub.com/forum/if-x-is-a-number-such-that-2-x-2-which-of-41132.html
Title: If x is a number such that -2 ≤ x ≤ 2, which of the following has the largest possible absolute value? 1. 3x - 1 2. x^2 + 1 3. 3 – x 4. x – 3 5. x^2 – x

URL: http://www.phpbb-seo.com/
Title: Search Engine Optimization

Open in new window

0
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
Eliminating tuples where the URL doesn't end in html gives the following:
URL: http://gmatclub.com/forum/if-d-9-2d-then-d-41301.html
Title: If |d - 9| = 2d, then d= (A) -9 (B) -3 (C) 1 (D) 3 (E) 9

URL: http://gmatclub.com/forum/if-x-y-x-y-and-xy-does-not-equal-0-which-of-the-followin-186803.html
Title: Tough and Tricky questions: Absolute Values. If |x | + |y | = -x – y and xy does not equal 0, which of the following must be true? A. x + y 0 B. x + y 0 C. x – y 0 D. x – y 0 E. x^2 – y^2 0

URL: http://gmatclub.com/forum/if-a-1-3-and-b-2-3-which-of-the-following-cannot-be-the-resul-186802.html
Title: Tough and Tricky questions: Absolute Values. If |a| = 1/3 and |b| = 2/3, which of the following CANNOT be the result of a + b? A. -1 B. -1/3 C. 1/3 D. 2/3 E. 1

URL: http://gmatclub.com/forum/if-x-0-then-root-x-2-x-64138.html
Title: If x\neq{0} , then \frac{ x^2 }{x}= A. -1 B. 0 C. 1 D. x E. \frac{|x|}{x} OPEN DISCUSSION OF THIS QUESTION IS HERE: if-x-0-then-root-x-2-x-87970.html 

URL: http://gmatclub.com/forum/a-b-which-of-the-following-must-be-true-141468.html
Title: |a|=|b|, which of the following must be true : I. a=b II. |a|=-b III. -a=-b A. I only B. II only. C. III only. D. I and III only. E. None

URL: http://gmatclub.com/forum/if-x-and-y-are-integers-such-that-x-1-2-less-than-equal-to-97992.html
Title: If x and y are integers such that (x+1)^2 less than equal to 36 and (y-1)^2 less than 64. What is the largest possible and minimum possible value of xy. In equalities how to handle an expression which is squared Does the above equation (x+1)^2 = 36 mean |x+1| (+6 or -...

URL: http://gmatclub.com/forum/if-y-y-0-which-of-the-following-must-be-true-131099.html
Title: If y + | y | = 0, which of the following must be true? A. y 0 B. y≥0 C. y 0 D. y≤0 E. y = 0 Why is just E incorrect?

URL: http://gmatclub.com/forum/what-is-the-sum-of-all-roots-of-the-equation-85988.html
Title: What is the sum of all roots of the equation |x + 4|^2 - 10|x + 4| = 24? Please help me find my mistake: Let x+4=y Now we get two cases, Case1: y^2-10y-24=0 Solving we get -2,12 Case2: -y^2+10y-24=0 where we get 6,4

URL: http://gmatclub.com/forum/which-of-the-following-inequalities-has-a-solution-set-that-130666.html
Title: Which of the following inequalities has a solution set that, when graphed on a number line, is a single, finite line segment? A. x=4 B. x^2=4 C. x^3=64 D. |x|=4 E. |x|=4

URL: http://gmatclub.com/forum/how-many-different-values-of-positive-integer-x-for-which-175948.html
Title: How many different values of positive integer x, for which |x+8|x, are there? A. 0 B. 2 C. 3 D. 8 E. 16

URL: http://gmatclub.com/forum/for-what-value-of-x-is-x-3-x-1-x-148561.html
Title: For what value of x, is |x – 3| + |x + 1| + |x| = 10? (A) 0 (B) 3 (C) -3 (D) 4 (E) -2

URL: http://gmatclub.com/forum/if-x-0-then-square-root-of-x-x-is-93776.html
Title: If x0, then -x|x| is: A. -x B. -1 C. 1 D. x E. x 

URL: http://gmatclub.com/forum/which-of-the-following-inequalities-is-an-algebraic-expressi-144267.html
Title: Line.png Which of the following inequalities is an algebraic expression for the shaded part of the number line above? (A) |x| = 3 (B) |x| = 5 (C) |x - 2| = 3 (D) |x - 1| = 4 (E) |x +1| = 4

URL: http://gmatclub.com/forum/is-r-s-110584.html
Title: Is r s ? (1) -r + s 0 (2) r | s | OPEN DISCUSSION OF THIS QUESTION IS HERE: is-r-s-1-r-s-0-2-r-s-126745.html 

URL: http://gmatclub.com/forum/which-of-the-following-inequalities-is-an-algebraic-78417.html
Title: number line.png Which of the following inequalities is an algebraic expression for the shaded part of the number line above? (A) |x| = 3 (B) |x| = 5 (C) |x - 2| = 3 (D) |x - 1| = 4 (E) |x +1| = 4 OPEN DISCUSSION OF THIS QUESTION IS HERE: which-of-the-following-inequalities-is-an...

URL: http://gmatclub.com/forum/if-y-1-2-11-2-which-of-the-following-could-be-a-value-136878.html
Title: If |y- 1/2 | 11/2 , which of the following could be a value of y? (A) -11 (B) -11/2 (C) 11/2 (D) 11 (E) 22 Practice Questions Question: 14 Page: 154 Difficulty: 600 

URL: http://gmatclub.com/forum/if-x-y-and-xy-0-which-of-the-following-must-be-true-164829.html
Title: If |x| = |y| and xy 0, which of the following must be true? A. xy^2 0 B. yx^2 0 C. x + y = 0 D. x/y +1=2 E. 1/x + 1/y = 1/2]

URL: http://gmatclub.com/forum/which-of-the-following-represents-1-x-126845.html
Title: Which of the following represents 1x9? A. |x|3 B. |x+5|4 C. |x-1|9 D. |-5+x|4 E. |3+x|5 How to do this quickly? The way I m doing it ( i.e. solving each statement possibilities ) takes 3-4 min.

URL: http://gmatclub.com/forum/if-x-x-which-of-the-following-must-be-true-169104.html
Title: If |x|=−x, which of the following must be true? A. x≥0 B. x≤0 C. x2x D. x30 E. 2xx

URL: http://gmatclub.com/forum/if-x-0-then-root-x-2-x-87970.html
Title: If x\neq{0} , then \frac{ x^2 }{x}= A. -1 B. 0 C. 1 D. x E. \frac{|x|}{x} 

URL: http://gmatclub.com/forum/what-inequality-represents-the-condition-1-x-94759.html
Title: What inequality represents the condition 1x9? (A) |x|3 (B) |x+5|4 (C) |x-1|9 (D) |-5+x|4 (E) |3+x|5 OPEN DISCUSSION OF THE QUESTION IS HERE: which-of-the-following-represents-1-x-126845.html Solution: 10sec. Traditional 3-steps method is too time-consume technique. First of all w...

URL: http://gmatclub.com/forum/if-x-x-then-which-one-of-the-following-statements-90747.html
Title: If x = - |x| , then which one of the following statements could be true? I. x = 0 II. x 0 III. x 0 (A) None (B) I only (C) III only (D) I and II (E) II and III

URL: http://gmatclub.com/forum/which-of-the-following-inequalities-is-always-true-for-any-142171.html
Title: Which of the following inequalities is always true for any real number 'a' and 'b'? (A) |a + b| = |a| + |b| (B) |a + b| |a| + |b| (C) |a + b| = |a| + |b| (D) |a - b| = |a| - |b| (E) |a - b| |a| - |b|

URL: http://gmatclub.com/forum/if-n-is-a-positive-integer-which-of-the-following-is-a-poss-65782.html
Title: If n is a positive integer, which of the following is a possible value of |56 - 5n| ? A. 7 B. 9 C. 12 D. 15 E. 20

URL: http://gmatclub.com/forum/of-the-five-coordinates-associated-with-points-a-b-c-d-63755.html
Title: http://gmatclub.com/forum/download/file.php?id=18091 Of the five coordinates associated with points A, B, C, D, and E on the number line above, which has the greatest absolute value? (A) A (B) B (C) C (D) D (E) E OPEN DISCUSSION OF THIS QUESTION IS HERE: of-the-five-...

URL: http://gmatclub.com/forum/if-y-is-an-integer-then-the-least-possible-value-of-139867.html
Title: If y is an integer, then the least possible value of |23 - 5y| is (A) 1 (B) 2 (C) 3 (D) 4 (E) 5 Practice Questions Question: 51 Page: 159 Difficulty: 600 

URL: http://gmatclub.com/forum/if-10y-4-7-and-y-1-which-of-the-following-could-be-y-137730.html
Title: If |10y - 4| 7 and y 1, which of the following could be y? A. -0.8 B. -0.1 C. 0.1 D. 0 E. 1

URL: http://gmatclub.com/forum/4-157041.html
Title: |-4| (|-20|-|5|)= ?? A. –100 B. –60 C. 60 D. 75 E. 100 Source: Preparation Material MBA Center

URL: http://gmatclub.com/forum/if-3-3-x-7-what-is-the-product-of-all-the-possible-va-150043.html
Title: If 3|3 – x| = 7, what is the product of all the possible values of x? A. 1/9 B. 1/3 C. 2/3 D. 16/9 E. 32/9

URL: http://gmatclub.com/forum/if-a-b-a-b-then-a-b-must-be-equal-to-135283.html
Title: If |a+b|=|a-b|, then a*b must be equal to: A. 1 B. -1 C. 0 D. 2 E. -2

URL: http://gmatclub.com/forum/of-the-five-coordinates-associated-with-points-a-b-c-d-137537.html
Title: ABCDE.png Of the five coordinates associated with points A, B, C, D, and E on the number line above, which has the greatest absolute value? (A) A (B) B (C) C (D) D (E) E Practice Questions Question: 24 Page: 155 Difficulty: 600 

URL: http://gmatclub.com/forum/if-y-is-an-integer-then-the-least-possible-value-of-132062.html
Title: If y is an integer, then the least possible value of |23 – 5y| is A. 1 B. 2 C. 3 D. 4 E. 5 |23-5y| represents the distance between 23 and 5y on the number line. Now, the distance will be minimized when 5y, which is multiple of 5, is closest to 23. Multiple of 5 which is closest ...

URL: http://gmatclub.com/forum/absolute-value-query-122239.html
Title: What inequality represents the condition 1x9? (A) |x|3 (B) |x+5|4 (C) |x-1|9 (D) |-5+x|4 (E) |3+x|5 OPEN DISCUSSION OF THE QUESTION IS HERE: which-of-the-following-represents-1-x-126845.html TOPIC LOCKED. MODERATOR. The answer to this question is D. I am confused because even C s...

URL: http://gmatclub.com/forum/is-r-s-1-r-s-0-2-r-s-127745.html
Title: Is r s ? (1) -r + s 0 (2) r |s| OA.A is my interpretation of statement 2 wrong? |s|r. so, s-r or sr if sr. r is not greater than s so sufficient if s-r, means r-s. if r is less than -s it cannot be greater than s so sufficient. Answer should be D. Please explain

URL: http://gmatclub.com/forum/modules-109065.html
Title: Q35: If n is a positive integer, which of the following is a possible value of |56 - 5n|? A. 7 B. 9 C. 12 D. 15 E. 20 how we can compute value in this pls help

URL: http://gmatclub.com/forum/of-the-five-coordinates-associated-with-points-a-b-c-d-an-106483.html
Title: http://gmatclub.com/forum/download/file.php?id=13663 Of the five coordinates associated with points A, B, C, D and E on the number line above, which has the greatest absolute value? A. A B. B C. C D. D E. E

URL: http://gmatclub.com/forum/if-y-y-0-which-of-the-following-must-be-true-93878.html
Title: If y + |y| = 0 which of the following must be true? A. y 0 B. y = 0 C. y 0 D. y = 0 E. y = 0

URL: http://gmatclub.com/forum/if-x-is-a-number-such-that-2-x-2-which-of-41132.html
Title: If x is a number such that -2 ≤ x ≤ 2, which of the following has the largest possible absolute value? 1. 3x - 1 2. x^2 + 1 3. 3 – x 4. x – 3 5. x^2 – x

Open in new window

0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 45

Expert Comment

by:aikimark
Comment Utility
What URL resulted in the pagehtml.txt that you posted?
0
 

Author Comment

by:Jay Balu
Comment Utility
Brilliant! I am looking exactly for the result that does not contain .html.

I used a "InternetOpenUrl" to generate the "pagehtml". It's rudimentary at best but it gets the job done. Why do you ask?
0
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
What was the URL that you used as the source of the pagehtml.txt file?
0
 

Author Comment

by:Jay Balu
Comment Utility
Sorry...it's well past midnight here :)

The URL is:
http://gmatclub.com/forum/search.php?search_tags=all&selected_search_tags%5B%5D=58&selected_search_tags%5B%5D=217

Open in new window

0
 
LVL 45

Accepted Solution

by:
aikimark earned 500 total points
Comment Utility
Public Sub Q_28568498()
    Dim oXMLHTTP As Object
    Dim strHTML As String
    Dim oRE As Object
    Dim oMatches As Object
    Dim oM As Object
    Dim oSM As Object
    Dim lngSM As Long

    Set oRE = CreateObject("vbscript.regexp")
    oRE.Global = True
    oRE.Pattern = "<td(?:\s|\S)*?<a href=""([^""]*.html)"" title=""([^""]*)"" *>(?:\s|\S)*?</td>"

    Set oXMLHTTP = CreateObject("MSXML2.XMLHTTP")
    oXMLHTTP.Open "GET", "http://gmatclub.com/forum/search.php?search_tags=all&selected_search_tags%5B%5D=58&selected_search_tags%5B%5D=217", False
    oXMLHTTP.Send
    
    Do Until oXMLHTTP.ReadyState = 4
        DoEvents
    Loop
    
    If oXMLHTTP.Status = 200 Then
        strHTML = oXMLHTTP.responsetext
        'parse the result
        If oRE.test(strHTML) Then
            Set oMatches = oRE.Execute(strHTML)
            For Each oM In oMatches
                With oM
                    Debug.Print "URL: ", .submatches(0)
                    Debug.Print "Title: ", .submatches(1)
                End With
            Next
        End If
        'persist the result
    End If

End Sub

Open in new window

0
 

Author Closing Comment

by:Jay Balu
Comment Utility
Wonderful! Just like I wanted!!
0
 

Author Comment

by:Jay Balu
Comment Utility
Aikimarl - Is there anyway I could increase the points on this question to 1000? I have another similar question but the data to be extracted looks different. Or maybe I should create a new question altogether but I want a "regular expression" type answer.
0
 

Author Comment

by:Jay Balu
Comment Utility
Aikimark - If you are interested to answer a similar question

http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_28569164.html
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now