Matching VentureOne (Data)

McNair Project

Matching VentureOne (Data)
Project Information
Project Title
Start Date
Deadline
Primary Billing
Notes
Has project status
Copyright © 2016 edegan.com. All Rights Reserved.

Data

1. Get the source file for the VentureOne data

E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx Original data source

1. Clean it up

E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txt extraneous symbols and words removed

1. Match it against itself

E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx

1. Get the patent data
   1. Draw the distinct assignees

Z:\allpatent\DistinctAssignees2.txt

1. 1. Match them against themselves

Z:\allpatent\DistinctAssignees2matched.txt

1. Load the VebtureOne data into a dbase