Changes

Regular Expression Cheat Sheet (view source)

2 bytes removed , 16:40, 21 September 2016

#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)

874

edits