Regular Expression Cheat Sheet

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

1. Filtered Lex Machina until total patents were under 2000.
2. Lex Machina ran its Patent Portfolio Report
3. Ctrl-A to select all, then pasted into TextPad

• Patent numbers were the first word in every line

1. Used replace command (F8) to find "(^.+?)\s.*$" and replace with "\1"

• Make sure "regular expression" is checked off

1. That left only the patent numbers
2. Repeated above steps until all 2015 patents are in TextPad
3. Exported data to Excel and then Removed Duplicates (Data --> Remove Duplicates)