The two public (actually this includes everything that isn't private) M&A pulls were normalized and then combined to create:
USMAPublic80-20H1-normal.txt
The various target statuses in this file are:
Govt. 333
Inv. 1
J.V. 2626
Mutual 218
Public 66176
Sub. 111796
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 fix the header first, so that the capital under management header entry has some space after it. 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.