Solved

# Extract data from html <td> tags using vb6

Posted on 2014-11-24
204 Views
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 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>

PageHTML.txt
0
Question by:Jay Balu
• 7
• 7

LVL 45

Expert Comment

ID: 40462527
From the HTML snippet you posted, what text do you need to parse
0

LVL 47

Expert Comment

ID: 40462561
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")

Do While Not fsoStream.AtEndOfStream
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

0

LVL 45

Expert Comment

ID: 40462597
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: /tests
Title: CAT Tests

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

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

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

0

Author Comment

ID: 40462668
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

ID: 40462693
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 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>


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" >

0

LVL 45

Expert Comment

ID: 40462762
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

0

LVL 45

Expert Comment

ID: 40462772
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

0

LVL 45

Expert Comment

ID: 40462781
What URL resulted in the pagehtml.txt that you posted?
0

Author Comment

ID: 40462854
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

ID: 40462900
What was the URL that you used as the source of the pagehtml.txt file?
0

Author Comment

ID: 40463002
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

0

LVL 45

Accepted Solution

aikimark earned 500 total points
ID: 40463097
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

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

0

Author Closing Comment

ID: 40464426
Wonderful! Just like I wanted!!
0

Author Comment

ID: 40464430
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

ID: 40464487
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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

A short article about a problem I had getting the GPS LocationListener working.
Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Starting up a Project