Trying to get an exact text match

[Jalz]

Hi Guys,

I have two fields, field 1 contains the data

New York

however field 2 contains the data

London

Milan

New York

New York2

Madrid

What formula can I use in a calculation to say if the content/value of Field 1 is in field 2, than display a True, Else display false.

The values in field two are seperated by a carriage return.

Many Thanks for your help

Jalz

[comment]

Try:

not IsEmpty ( FilterValues ( item ; list ) )

[IdealData]

Have you considered setting up a relationship?

field1 --> field2

You can then test with

field1 = relationship::field2

The relationship may also be handy for value lists etc.