7,619
edits
Changes
Jump to navigation
Jump to search
→Long Description
#Run the normalizer
#Remove duplicate spaces from the description column by pushing the data through excel and running the last regex (save as In5.txt with UNIX/UTF-8)
#Remove quote marks from Out5.txt, resave and then put back into excel to create USVCPortCoLongDesc1980Cleaned.txt
cat Process.txt | perl -pe 's/^([^ ])/###\1/g' > Out1.txt
cat Out2.txt | perl -pe 's/\n//g' > Out3.txt
cat Out3.txt | perl -pe 's/###/\n/g' > Out4.txt
... cat In5.txt | perl -pe 's/\s{2,}/ /g' > Out4Out5.txt
===Round On One Line===
