Finding a match between subfields of two strings

[#1]

Is there an expression that can find matches between substrings of two fields that both have comma delimitted substrings?

Field_1 = 'USA', 'Italy', 'Japan'

Field_2 = 'Jamaica', 'Italy', 'Australia', 'Korea', 'China', 'Chile', 'Mexico'

Is there an expression I can use in a text object or a chart, to tell that Field1 and Field 2 do have a match  WITHOUT using the load script?

In the example above, both fields have 'Italy'. The expression would help to determine that both Field_1 and Field_2 contain 'Italy'.

[tresesco]

Ideally, you should use subfield function during LOAD to generate one full record of input data for each substring. Once done, you can easily compare the vaules from different fields.

Thanks.

[#3]

Use the InterRecord function lookup...

[#4]

see attachement