Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 10-29-2015, 11:33 PM
PRA007's Avatar
PRA007 PRA007 is offline Find what and copy that Windows 7 32bit Find what and copy that Office 2010 32bit
Competent Performer
Find what and copy that
 
Join Date: Dec 2014
Location: Ahmedabad, Gujrat, India
Posts: 145
PRA007 is on a distinguished road
Default

I have word 5 column table containing patent numbers like this in column 2.

WO 2001/042246 A3
(Pfizer)
EP 1235830 B1;
EP 1382339 B1;
US 6,627,754 B2;
US 6,956,041 B2;
US 7,091,208 B2;
US 7,265,221 B2;
US 7,601,727 B2;
US 7,842,699 B2;
US 41783 E1;
IN 241773 A1;
US 6,627,754 B2

I want to perform following steps


1)
Find "US ([3-9]),([0-9]{3}),([0-9]{3})"
Replace with "US \1\2\3"

2)
Find "US ([0-9]{5} )"
Replace with "US RE\1"

3)
Find all occurences of US [R3-9][0-9E]{6}
copy, add new doccument, paste.

4)
In new document
Find "US "
Replace with ""
save new document as text file (i.txt) in desktop.
Close new document

5) in original document
find "US ([3-9])([0-9]{3})([0-9]{3})"
Replace with "US \1,\2,\3
save current doccument.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find what and copy that Find specific rows then copy and paste to new doc konopca Word VBA 5 02-20-2014 02:34 PM
Find what and copy that Find Results in excel copy the rows to another sheet khalidfazeli Excel 2 02-06-2013 09:38 AM
Find what and copy that Find, copy and paste into a new page jperez84 Word VBA 24 09-20-2012 11:34 AM
Find what and copy that Macro that can find phrase and then find another and copy jperez84 Word VBA 10 09-19-2012 04:48 PM
Trying to find and copy all headings at the same time WaltR Word 7 08-21-2012 03:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:21 AM.


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