Changes

 ==Summary== This page <onlyinclude>The [[VCDB20H1]] project documents the build of vcbd20h1-- a '''V'''enture '''C'''apital '''D'''ata'''B'''ase covering until the end of the first half ('''H1''') of 20'''20'''. Vcbd20h1 includes investments, funds, startups, executives, and exits derived from data from [[VentureXpert]]. It This project updates [[vcdb4]], which covered (almost) to the of Q3 2019, to until the end of the first half (H1) of 2020.See also: [[SDC Normalizer]].</onlyinclude>

Normalizing the files is generally straight-forward. Use NormalizeFixedWidth.pl (see [[Normalizer Documentation]]) and only copy down the missing keys (e.g., coname, statecode, datefirst, etc.). For most files there is nothing to fix, just select the last header row and go. For fund firm fix the header first, so that the capital under management header entry has some space after it(otherwise it blends with the firm status). For RoundOnOneLine, remove the footer, run NormalizeFixedWidth.pl first then RoundOnOneLine.pl, and then fix the header. For fund, fund execs, and portco, remove double quotes after normalization. For M&As, replace \tnp\t and \tnm\t with \t\t.

*The Stage Level 3 (in Round) options now include secondary purchase , secondary buyout, and open market purchase.