Thread: [Solved] Find what and copy that
View Single Post
 
Old 10-29-2015, 11:33 PM
PRA007's Avatar
PRA007 PRA007 is offline Windows 7 32bit Office 2010 32bit
Competent Performer
 
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