Jay Balu

asked on

# Extract data from html <td> tags using vb6

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!

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&t=41301&view=unread&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>
<p>
Tags: <a href="./search.php?search_id=tag&tag_id=217&sid=e529503533ca87ee136c986f3c5d6e66">Difficulty: Sub-600 Level</a>, <a href="./search.php?search_id=tag&tag_id=58&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
From the HTML snippet you posted, what text do you need to parse

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

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

ASKER

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.

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.

ASKER

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,

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

```
<td class="topicsName" style="width:100%">
<a class="newestPostIcon" href="http://gmatclub.com/forum/viewtopic.php?f=140&t=41301&view=unread&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>
<p>
Tags: <a href="./search.php?search_id=tag&tag_id=217&sid=e529503533ca87ee136c986f3c5d6e66">Difficulty: Sub-600 Level</a>, <a href="./search.php?search_id=tag&tag_id=58&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" >`

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

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

What URL resulted in the pagehtml.txt that you posted?

ASKER

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?

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

What was the

**URL**that you used as the source of the pagehtml.txt file?ASKER

Sorry...it's well past midnight here :)

The URL is:

The URL is:

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

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Wonderful! Just like I wanted!!

ASKER

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.

ASKER

Aikimark - If you are interested to answer a similar question

https://www.experts-exchange.com/questions/28569164/Extract-specfic-data-between-div-tags-using-RegEx-in-visual-basic-using-RegEx.html

https://www.experts-exchange.com/questions/28569164/Extract-specfic-data-between-div-tags-using-RegEx-in-visual-basic-using-RegEx.html