Wrox Programmer Forums
Go Back   Wrox Programmer Forums > XML > XML
| Search | Today's Posts | Mark Forums Read
XML General XML discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the XML section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 13th, 2007, 04:04 PM
Registered User
 
Join Date: Jul 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default HELP - Find text / Replace with email link (XML or

I'm new to both XML and ASP.NET (vb), but what I want to do doesn't sound like it should be

hard but I can't figure it out.

I have an excel file with one cell containing a paragraph of text. I have this data

exported as XML and loaded in an ASP.NET page using asp:Xml to display. This all works

fine, what I want to add is a script that will read the text that is exported and look for

a person’s name. If it finds their name, replace with an active HTML email link.

Is this possible?

Where should I do this? In the XML? As a separate ASP.NET (vb) script?

???

Thanks in advance for any help.

 
Old July 13th, 2007, 09:07 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

You can specify an XSL transformation file in the xml web control. So you could make a XSL transformation that does the replace. Here's an MSDN article about using the xml control that has a little bit in it about applying transformation. You'll have to figure out how to work the XSL XPath queries to modify the input to change the values.

http://support.microsoft.com/kb/315906

-Peter




Similar Threads
Thread Thread Starter Forum Replies Last Post
Search and Replace a text in XML file AyatKh XML 17 May 23rd, 2012 09:05 PM
XSL to replace text in XML file neetukk XSLT 1 November 29th, 2006 05:20 AM
Autofill text from an Email Link zanna5910 Access 1 September 28th, 2005 07:13 PM
Create a find and a find and replace in VB.NET snowy0 VB How-To 0 January 26th, 2004 07:03 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.