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.
|