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!

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

rivate Sub Form_Load()Dim fso As New FileSystemObjectDim f As FileDim fsoStream As TextStreamDim strLine As StringDim intPos As IntegerSet 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 IfLoopfsoStream.CloseSet fsoStream = NothingSet f = NothingSet fso = NothingEnd Sub

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!

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,

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

Here are all the URL and Title combinations inside <td></td> tags

URL: /forum/?fl=menuTitle: Forum Index PageURL: http://gmatclub.com/forum/if-d-9-2d-then-d-41301.htmlTitle: If |d - 9| = 2d, then d= (A) -9 (B) -3 (C) 1 (D) 3 (E) 9URL: http://gmatclub.com/forum/if-x-y-x-y-and-xy-does-not-equal-0-which-of-the-followin-186803.htmlTitle: 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 0URL: http://gmatclub.com/forum/if-a-1-3-and-b-2-3-which-of-the-following-cannot-be-the-resul-186802.htmlTitle: 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. 1URL: http://gmatclub.com/forum/if-x-0-then-root-x-2-x-64138.htmlTitle: 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.htmlTitle: |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. NoneURL: http://gmatclub.com/forum/if-x-and-y-are-integers-such-that-x-1-2-less-than-equal-to-97992.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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,4URL: http://gmatclub.com/forum/which-of-the-following-inequalities-has-a-solution-set-that-130666.htmlTitle: 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|=4URL: http://gmatclub.com/forum/how-many-different-values-of-positive-integer-x-for-which-175948.htmlTitle: How many different values of positive integer x, for which |x+8|x, are there? A. 0 B. 2 C. 3 D. 8 E. 16URL: http://gmatclub.com/forum/for-what-value-of-x-is-x-3-x-1-x-148561.htmlTitle: For what value of x, is |x Ã¢â‚¬â€œ 3| + |x + 1| + |x| = 10? (A) 0 (B) 3 (C) -3 (D) 4 (E) -2URL: http://gmatclub.com/forum/if-x-0-then-square-root-of-x-x-is-93776.htmlTitle: 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.htmlTitle: 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| = 4URL: http://gmatclub.com/forum/is-r-s-110584.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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.htmlTitle: If |x|=Ã¢Ë†â€™x, which of the following must be true? A. xÃ¢â€°Â¥0 B. xÃ¢â€°Â¤0 C. x2x D. x30 E. 2xxURL: http://gmatclub.com/forum/if-x-0-then-root-x-2-x-87970.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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 IIIURL: http://gmatclub.com/forum/which-of-the-following-inequalities-is-always-true-for-any-142171.htmlTitle: 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.htmlTitle: 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. 20URL: http://gmatclub.com/forum/of-the-five-coordinates-associated-with-points-a-b-c-d-63755.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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. 1URL: http://gmatclub.com/forum/4-157041.htmlTitle: |-4| (|-20|-|5|)= ?? A. Ã¢â‚¬â€œ100 B. Ã¢â‚¬â€œ60 C. 60 D. 75 E. 100 Source: Preparation Material MBA CenterURL: http://gmatclub.com/forum/if-3-3-x-7-what-is-the-product-of-all-the-possible-va-150043.htmlTitle: 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/9URL: http://gmatclub.com/forum/if-a-b-a-b-then-a-b-must-be-equal-to-135283.htmlTitle: If |a+b|=|a-b|, then a*b must be equal to: A. 1 B. -1 C. 0 D. 2 E. -2URL: http://gmatclub.com/forum/of-the-five-coordinates-associated-with-points-a-b-c-d-137537.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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 explainURL: http://gmatclub.com/forum/modules-109065.htmlTitle: 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 helpURL: http://gmatclub.com/forum/of-the-five-coordinates-associated-with-points-a-b-c-d-an-106483.htmlTitle: 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. EURL: http://gmatclub.com/forum/if-y-y-0-which-of-the-following-must-be-true-93878.htmlTitle: 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 = 0URL: http://gmatclub.com/forum/if-x-is-a-number-such-that-2-x-2-which-of-41132.htmlTitle: 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 ÃƒÂ¢Ã¢â€šÂ¬Ã¢â‚¬Å“ xURL: 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.htmlTitle: If |d - 9| = 2d, then d= (A) -9 (B) -3 (C) 1 (D) 3 (E) 9URL: http://gmatclub.com/forum/if-x-y-x-y-and-xy-does-not-equal-0-which-of-the-followin-186803.htmlTitle: 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 0URL: http://gmatclub.com/forum/if-a-1-3-and-b-2-3-which-of-the-following-cannot-be-the-resul-186802.htmlTitle: 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. 1URL: http://gmatclub.com/forum/if-x-0-then-root-x-2-x-64138.htmlTitle: 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.htmlTitle: |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. NoneURL: http://gmatclub.com/forum/if-x-and-y-are-integers-such-that-x-1-2-less-than-equal-to-97992.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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,4URL: http://gmatclub.com/forum/which-of-the-following-inequalities-has-a-solution-set-that-130666.htmlTitle: 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|=4URL: http://gmatclub.com/forum/how-many-different-values-of-positive-integer-x-for-which-175948.htmlTitle: How many different values of positive integer x, for which |x+8|x, are there? A. 0 B. 2 C. 3 D. 8 E. 16URL: http://gmatclub.com/forum/for-what-value-of-x-is-x-3-x-1-x-148561.htmlTitle: For what value of x, is |x Ã¢â‚¬â€œ 3| + |x + 1| + |x| = 10? (A) 0 (B) 3 (C) -3 (D) 4 (E) -2URL: http://gmatclub.com/forum/if-x-0-then-square-root-of-x-x-is-93776.htmlTitle: 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.htmlTitle: 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| = 4URL: http://gmatclub.com/forum/is-r-s-110584.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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.htmlTitle: If |x|=Ã¢Ë†â€™x, which of the following must be true? A. xÃ¢â€°Â¥0 B. xÃ¢â€°Â¤0 C. x2x D. x30 E. 2xxURL: http://gmatclub.com/forum/if-x-0-then-root-x-2-x-87970.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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 IIIURL: http://gmatclub.com/forum/which-of-the-following-inequalities-is-always-true-for-any-142171.htmlTitle: 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.htmlTitle: 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. 20URL: http://gmatclub.com/forum/of-the-five-coordinates-associated-with-points-a-b-c-d-63755.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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. 1URL: http://gmatclub.com/forum/4-157041.htmlTitle: |-4| (|-20|-|5|)= ?? A. Ã¢â‚¬â€œ100 B. Ã¢â‚¬â€œ60 C. 60 D. 75 E. 100 Source: Preparation Material MBA CenterURL: http://gmatclub.com/forum/if-3-3-x-7-what-is-the-product-of-all-the-possible-va-150043.htmlTitle: 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/9URL: http://gmatclub.com/forum/if-a-b-a-b-then-a-b-must-be-equal-to-135283.htmlTitle: If |a+b|=|a-b|, then a*b must be equal to: A. 1 B. -1 C. 0 D. 2 E. -2URL: http://gmatclub.com/forum/of-the-five-coordinates-associated-with-points-a-b-c-d-137537.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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.htmlTitle: 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 explainURL: http://gmatclub.com/forum/modules-109065.htmlTitle: 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 helpURL: http://gmatclub.com/forum/of-the-five-coordinates-associated-with-points-a-b-c-d-an-106483.htmlTitle: 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. EURL: http://gmatclub.com/forum/if-y-y-0-which-of-the-following-must-be-true-93878.htmlTitle: 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 = 0URL: http://gmatclub.com/forum/if-x-is-a-number-such-that-2-x-2-which-of-41132.htmlTitle: 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

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 IfEnd Sub

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

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

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for freeEdge Out The Competitionfor your dream job with proven skills and certifications.Get started todayStand Outas the employee with proven skills.Start learning today for freeMove Your Career Forwardwith certification training in the latest technologies.Start your trial today