874
edits
Changes
Jump to navigation
Jump to search
Regular Expression Cheat Sheet (view source)
Revision as of 17:39, 21 September 2016
, 17:39, 21 September 2016Created 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..."
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)
==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)
