Link to home
Start Free TrialLog in
Avatar of Jay Balu
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!

<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
Avatar of aikimark
aikimark
Flag of United States of America image

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

Open in new window

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

Avatar of Jay Balu
Jay Balu

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

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

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

What URL resulted in the pagehtml.txt that you posted?
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?
What was the URL that you used as the source of the pagehtml.txt file?
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

ASKER CERTIFIED SOLUTION
Avatar of aikimark
aikimark
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Wonderful! Just like I wanted!!
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.