Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-03-2019, 02:49 PM
bonzai217 bonzai217 is offline Create a macro or Find/Replace Code to delete tags Mac OS X Create a macro or Find/Replace Code to delete tags Office 2019
Novice
Create a macro or Find/Replace Code to delete tags
 
Join Date: Aug 2019
Posts: 2
bonzai217 is on a distinguished road
Question Create a macro or Find/Replace Code to delete tags

Hello and Help!


I am exporting an .xml file from Word Press to Word that brings tags along with it. They aren't really html tags they are event tags from my calendar plug-in. I can use Find/Replace but there are 26 tags to remove so I am trying to create a macro to do this for me and am having no luck.

Here's what an entry looks like. There must be an easy way to do a macro or find/replace to take out everything inside and including the <>?

<event>
<organizer>ACC</organizer>
<organizer-phone>203-555-1212</organizer-phone>
<organizer-website>http://waterburyregionarts.com</organizer-website>
<organizer-email>info@ waterburyregionarts.com </organizer-email>
<venue>AACC</venue>
<address>123 Main Street South Southbury,CT 06488</address>
<phone>203-555-1212</phone>
<website>http://waterburyregionarts.com</website>
<title>Acrylic Pet Portraits</title>
<content>Acrylic Pet Portraits</content>
<eventdate>Sep. 9, 16, 23, 30: 10 am - 12 pm</eventdate>
<eventcost>130.00</eventcost>
</event>

Thanks in advance! I'm desperate.
Reply With Quote
  #2  
Old 08-03-2019, 04:07 PM
Robert2 Robert2 is offline Create a macro or Find/Replace Code to delete tags Windows 10 Create a macro or Find/Replace Code to delete tags Office 2007
Competent Performer
 
Join Date: Jun 2013
Posts: 162
Robert2 will become famous soon enoughRobert2 will become famous soon enough
Default

A simple wildcard Find/Replace operation should do the job:
Find What: \<*\>
Leave the Replace With box empty.
Click on Replace All.
Reply With Quote
  #3  
Old 08-04-2019, 08:36 AM
bonzai217 bonzai217 is offline Create a macro or Find/Replace Code to delete tags Mac OS X Create a macro or Find/Replace Code to delete tags Office 2019
Novice
Create a macro or Find/Replace Code to delete tags
 
Join Date: Aug 2019
Posts: 2
bonzai217 is on a distinguished road
Default Solved!!!

Thank you so much Robert2, that worked. I was so close didn't know I needed the \'s in the equation. A million thank yous to you my friend! :
Reply With Quote
Reply

Tags
deleting tags, find and replace, macros

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a macro or Find/Replace Code to delete tags Delete lines with just a number on them - use macro or find & replace? enso Word 2 05-20-2019 02:58 AM
Need help to create macro to find and replace if conditions are met limsp Excel Programming 1 04-19-2019 06:45 AM
Macro code that prompts user to enter text, then does find/replace. sfvegas PowerPoint 0 01-10-2016 08:02 PM
Looking for code to create a macro that prompts user to enter text, then does a find/replace. sfvegas PowerPoint 0 01-08-2016 02:22 AM
How to use Find and Replace with HTML tags? srz92 Word 0 07-17-2013 07:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft