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...") |
|||
| Line 13: | Line 13: | ||
#Lex Machina ran its Patent Portfolio Report | #Lex Machina ran its Patent Portfolio Report | ||
#Ctrl-A to select all, then pasted into TextPad | #Ctrl-A to select all, then pasted into TextPad | ||
| − | *Patent numbers were the first word in every line | + | **Patent numbers were the first word in every line |
#Used replace command (F8) to find "(^.+?)\s.*$" and replace with "\1" | #Used replace command (F8) to find "(^.+?)\s.*$" and replace with "\1" | ||
| − | *Make sure "regular expression" is checked | + | **Make sure "regular expression" is checked |
#That left only the patent numbers | #That left only the patent numbers | ||
#Repeated above steps until all 2015 patents are in TextPad | #Repeated above steps until all 2015 patents are in TextPad | ||
#Exported data to Excel and then Removed Duplicates (Data --> Remove Duplicates) | #Exported data to Excel and then Removed Duplicates (Data --> Remove Duplicates) | ||
Revision as of 16:40, 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
- 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)
