7,612
edits
Changes
Jump to navigation
Jump to search
no edit summary
[[VCDB23]] is the 2023 iteration of my venture capital database. The last previous build was [[VCBD20VCDB20]], and this follows the same basic design.
== Processing Steps ==
## The private and public M&A file sets have to be separately combined into 2 files after they've been normalized. Then replace \tnp\t and \tnm\t with \t\t in each.
## For RoundOnOneLine, remove the footer, run NormalizeFixedWidth.pl first, then RoundOnOneLine.pl, and then fix the header.
## PortCoLongDescription must be pre-processed from the command line and then post-processed in excel (see VCDB20H1 and Vcdb4#Long_Description). However, I didn't load it for this run.
# Create a new database on mother (createdb vcdb23) and setup a directory for the input files: E:\projects\vcdb23
# Copy over and edit Load.sql. Run it section-by-section.
