Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-24-2023, 01:24 PM
OmarFarouq OmarFarouq is offline Macro to extract all segments containing a forward slash Windows 10 Macro to extract all segments containing a forward slash Office 2021
Novice
Macro to extract all segments containing a forward slash
 
Join Date: Mar 2023
Posts: 1
OmarFarouq is on a distinguished road
Default Macro to extract all segments containing a forward slash

Dear Forum Members,

I need a macro to extract all segments that contain a forward slash from a Word document. Extraction better be into a new Excel file, but it can also be into a new Word document, or it can even work if the macro highlights all such segments (each segment is highlighted from start to end).

Here is one example of those segments:



UNEP/POPS/POPRC.16/9/Add.1

Pattern: XYZ/XYZ/XYZ.##/Xyz.#

An here is an example of a paragraph that contains those segments:

At its sixteenth, seventeenth and eighteenth meetings, the Committee, pursuant to paragraphs 6 and 7 (a) of Article 8 of the Convention, adopted the risk profiles and risk management evaluations for methoxychlor (UNEP/POPS/POPRC.16/9/Add.1 and UNEP/POPS/POPRC.17/13/Add.1); Dechlorane Plus (UNEP/POPS/POPRC.17/13/Add.2 and UNEP/POPS/POPRC.18/11/Add.1); and UV-328 (UNEP/POPS/POPRC.17/13/Add.3 and UNEP/POPS/POPRC.18/11/Add.2).

Many thanks in advance.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to extract all segments containing a forward slash VBA help with Date Format change period to forward slash for abbreviated dates Shelley Lou Word VBA 0 10-21-2021 01:28 AM
VBA rule to forward messages from specific folder and forward Bursal Outlook 16 09-23-2015 04:09 AM
Macro to extract all segments containing a forward slash VBA code for adding slash (/) Jasa P Word VBA 6 05-09-2012 10:12 AM
Macro to extract all segments containing a forward slash Macro will not carry forward to next spreadsheet… BudParker Excel Programming 1 01-07-2012 03:44 PM
A slash shows up before bookmarks Hunter Word 0 03-07-2010 05:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:13 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