7,612
edits
Changes
Jump to navigation
Jump to search
→Database import
*Fix the header row in USFirms1980.txt before normalizing (the Capital Under Management column name is too long)
*Remove double quotes from USFund1980-normal.txt, USFundExecs1980-normal.txt, USPortCo1980-normal.txt
*The private and public M&A files file sets have to be (separately) combined after they've been normalized. Then replace \tnp\t and \tnm\t with \t\t.
*For RoundOnOneLine, remove the footer, run NormalizeFixedWidth.pl first then RoundOnOneLine.pl, and then fix the header.
*The PortCo Long Description needs to be pre-processed from the command line and then post-processed in excel (see [[VCDB20H1]] and [[Vcdb4#Long_Description]]).
