root/inputs/MO/Specimen/postprocess.sql @ 7905
1 |
-- Remove frameshifted rows by detecting InstitutionCodes without any letters
|
---|---|
2 |
DELETE FROM :table |
3 |
WHERE NOT COALESCE("InstitutionCode" ~ '[[:alpha:]]', false) |
4 |
;
|