remove hyperlinks?

[middletree]

I have a page which takes data in an HTML table, and exports it to an Excel
file. It works fine, but I want several things about the spreadsheet to look
different from the HTML version. Things like fonts and colors. I think I can
use a style sheet for the latter, but I haven't figured out how to remove
hyperlinks from some of the items. On the HTML page, the hyperlinks are
useful, but I don't want the spreadsheet to have them.

So on my ASP page which builds the Excel file, I have this:

<TH vAlign=top align=left width="7%"><A
href="DisplaySo rtableTickets.a sp?SearchYes=tr ue&amp;selectTS E=200&amp;Assis t
Emp=&amp;Status =&amp;Environme nt=&amp;Custome rCode=&amp;date 1=&amp;date2=&a m
p;DateSearch=&a mp;Sort=TKTID&a mp;SortToggle=1 &amp;ReportType =&amp;ShowInter n
al=&amp;ShowExt ernal=&amp;sear chtext=&amp;Sea rchSDR=&amp;Sea rchCustTicketID =
&amp;RootCauseI D=&amp;CauseMat chType=">TKT ID:</A></TH>

How can I use ASP to remove the opening and closing <A> tags? A replace
function won't work, because it's different every time.

[Dave Anderson]

middletree wrote:

How can I use ASP to remove the opening and closing <A> tags? A
replace function won't work, because it's different every time.

Isn't that the whole point of pattern matching?

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[middletree]

What is pattern matching?
"Dave Anderson" <GT**********@s pammotel.com> wrote in message
news:#f******** ******@TK2MSFTN GP10.phx.gbl...

middletree wrote:

How can I use ASP to remove the opening and closing <A> tags? A
replace function won't work, because it's different every time.
Isn't that the whole point of pattern matching?

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message.

Use of this email address implies consent to these terms. Please do not contact me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[Dave Anderson]

middletree wrote:

What is pattern matching?

It's a codified way of doing what you already do when you manually strip the
HTML from a piece of text. Both VBScript and JScript allow you to do this
with Regular Expression Objects:

http://msdn.microsoft.com/library/en...sobjRegExp.asp
http://msdn.microsoft.com/library/en...expression.asp

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[middletree]

I looked over both articles, and am still not clear on what this has to do
with what I am asking about.
"Dave Anderson" <GT**********@s pammotel.com> wrote in message
news:eL******** ******@TK2MSFTN GP12.phx.gbl...

middletree wrote:

What is pattern matching?
It's a codified way of doing what you already do when you manually strip

the HTML from a piece of text. Both VBScript and JScript allow you to do this
with Regular Expression Objects:

http://msdn.microsoft.com/library/en...sobjRegExp.asp
http://msdn.microsoft.com/library/en...jregexpression
..asp
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use of this email address implies consent to these terms. Please do not contact me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[Chris Hohmann]

"middletree " <mi********@ver ywarmmail.com> wrote in message
news:es******** ******@tk2msftn gp13.phx.gbl...
[snip]

How can I use ASP to remove the opening and closing <A> tags? A replace
function won't work, because it's different every time.

<%
Dim s, re
s = "<a href='test.html '>Hello World.</a>"
Set re = New RegExp
re.Global = True
re.IgnoreCase = True
re.Pattern = "<a .*?>(.*?)</a>"
Response.Write re.Replace(s,"$ 1")
%>

[middletree]

Now that's something I can understand.

Thanks!
"Chris Hohmann" <no****@thankyo u.com> wrote in message
news:#M******** ******@TK2MSFTN GP14.phx.gbl...

"middletree " <mi********@ver ywarmmail.com> wrote in message
news:es******** ******@tk2msftn gp13.phx.gbl...
[snip]

How can I use ASP to remove the opening and closing <A> tags? A replace
function won't work, because it's different every time.

<%
Dim s, re
s = "<a href='test.html '>Hello World.</a>"
Set re = New RegExp
re.Global = True
re.IgnoreCase = True
re.Pattern = "<a .*?>(.*?)</a>"
Response.Write re.Replace(s,"$ 1")
%>

[Chris Hohmann]

"middletree " <mi********@HTO mail.com> wrote in message
news:%2******** *******@TK2MSFT NGP12.phx.gbl.. .

"Chris Hohmann" <no****@thankyo u.com> wrote in message
news:#M******** ******@TK2MSFTN GP14.phx.gbl...

"middletree " <mi********@ver ywarmmail.com> wrote in message
news:es******** ******@tk2msftn gp13.phx.gbl...
[snip]

> How can I use ASP to remove the opening and closing <A> tags? A replace
> function won't work, because it's different every time.

<%
Dim s, re
s = "<a href='test.html '>Hello World.</a>"
Set re = New RegExp
re.Global = True
re.IgnoreCase = True
re.Pattern = "<a .*?>(.*?)</a>"
Response.Write re.Replace(s,"$ 1")
%>

Now that's something I can understand.

Thanks!

Actually, in the long run, Dave's tactic is more worthwhile. He was trying
to bring you close enough to the answer so you could make the mental leap
for yourself. I GAVE you a fish, he tried to TEACH you how to fish. There a
world of difference between the two.

[middletree]

"Chris Hohmann" <no****@thankyo u.com> wrote in message
news:#G******** ******@TK2MSFTN GP10.phx.gbl...

Actually, in the long run, Dave's tactic is more worthwhile. He was trying
to bring you close enough to the answer so you could make the mental leap
for yourself. I GAVE you a fish, he tried to TEACH you how to fish. There

a world of difference between the two.

I totally understand. But it was so far above my head, covering several
things I have never seen before, that I couldn't make the leap. Your
example, combined with what I read in the articles referenced in his post,
have worked together quite well.

[Chris Hohmann]

"middletree " <mi********@ver ywarmmail.com> wrote in message
news:OI******** ******@TK2MSFTN GP09.phx.gbl...

"Chris Hohmann" <no****@thankyo u.com> wrote in message
news:#G******** ******@TK2MSFTN GP10.phx.gbl...

>

Actually, in the long run, Dave's tactic is more worthwhile. He was
trying
to bring you close enough to the answer so you could make the mental leap
for yourself. I GAVE you a fish, he tried to TEACH you how to fish. There

a

world of difference between the two.

I totally understand. But it was so far above my head, covering several
things I have never seen before, that I couldn't make the leap. Your
example, combined with what I read in the articles referenced in his post,
have worked together quite well.

I'm glad we could help. :)