I tried with find-replace, but it showed a warning about field 6 containing too many characters, so I abandoned that one and chose to use the append tool. Then it's just a matter of checking if the search text is present, then filtering, concatenating and counting.