Hello,
I have a list of countries in csv format e.g.: ALBANIA, AUSTRALIA, COLOMBIA, CHILE, NORWAY etc. and I have some records I'm reading from a database. I would like to find out if the description part of these records contains one of these countries from the csv. A description could be : CHINESE NOTICE 14/261; JAPANESE NOTICE 28; GERMAN NOTICE 23; COLOMBIAN NOTICE 172; SWEDISH NOTICE 593; GREEK CHART 311; AUSTRALIAN NOTICE 993. So the country name is not necessarily complete (Chinese, Swedish) or the description is longer than the country name (Japanese, Australian). Any tips what transformer to use? Thanks!