220
edits
Changes
Jump to navigation
Jump to search
Retrieving US VC Data From SDC (view source)
Revision as of 11:59, 21 June 2017
, 11:59, 21 June 2017→Scripts and other info
cat Out2.txt | perl -pe 's/\n//g' > Out3.txt
cat Out3.txt | perl -pe 's/#/\n/g' > Out4.txt
You will still have an issue running the normalizer on Out4.txt. I appended 100,000 filler characters to the last column header so that the normalizer will space things properly. However, the final output will have some long descriptions split across two lines. This will cause problems copying to a psql table. You will have to manually adjust these lines. Also remove all quotation marks from the text file because these will just cause trouble.
==Build Specs==
