I cannot figure out how to exclude names containing 'coach'.
1 as Counter,
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
WHERE LEGAL_NAME <> '*coach*';
(if you're dealing with a massive data set at some point it might be better to load all the "Coach" values first and do a left keep to eliminate them from the full table load - for performance reasons. )