help - i cant get this calculation to work

[David Waxtel]

how do you get a text field to read a repeating field with text....i cant get a result of 1 or 2

Example: I have a text field-A with text in it "M-01"

Then i have Repeating field with text in it "S-01", "W-01", "M-01"

I need a calculation that says that Text field A has something in common with the Repeating field...the "M-01 is in both fields"....need a number result of 1...meaning yes

If the Text field A does not match the repeating field then i need a number of 0...meaning no

[comment]

Please do not double post:

http://fmforums.com/forum/showtopic.php?tid/198525/