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
Jay BaluAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

aikimarkCommented:
From the HTML snippet you posted, what text do you need to parse
0
Martin LissOlder than dirtCommented:
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
aikimarkCommented:
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jay BaluAuthor Commented:
Wonderful! Just like I wanted!!
0
Jay BaluAuthor Commented:
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
Jay BaluAuthor Commented:
Aikimark - If you are interested to answer a similar question

http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_28569164.html
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.