Project

General

Profile

Download (160 Bytes) Statistics
| Revision:

root/inputs/MO/Specimen/postprocess.sql @ 7879

1 7520 aaronmk 
-- Remove frameshifted rows by detecting InstitutionCodes without any letters
2 7701 aaronmk 
DELETE FROM :table
3 7700 aaronmk 
WHERE NOT COALESCE("InstitutionCode" ~ '[[:alpha:]]', false)
4 7520 aaronmk 
;