Difference between revisions of "Regular Expression Cheat Sheet"
Jump to navigation
Jump to search
(Created page with "This is a page for regular expression hacks. Chronicle your exploits so that others can benefit from your ingenuity! ==Lex Machina== ===Task=== Use Patent Portfolio Report...") |
(No difference)
|
Revision as of 16:39, 21 September 2016
This is a page for regular expression hacks. Chronicle your exploits so that others can benefit from your ingenuity!
Lex Machina
Task
Use Patent Portfolio Report to pull unique patent numbers for patents litigated in 2015
Steps Taken
- Filtered Lex Machina until total patents were under 2000.
- Lex Machina ran its Patent Portfolio Report
- Ctrl-A to select all, then pasted into TextPad
- Patent numbers were the first word in every line
- Used replace command (F8) to find "(^.+?)\s.*$" and replace with "\1"
- Make sure "regular expression" is checked off
- That left only the patent numbers
- Repeated above steps until all 2015 patents are in TextPad
- Exported data to Excel and then Removed Duplicates (Data --> Remove Duplicates)
