Perform find with variable and quotations

[innodat]

I need to search for an email address in my database. As you know the address needs to be enclosed in "...", like "[email protected]", for it to return any search results.

I need to execute that find with the help of a variable:

Enter Find Mode

Set field ($EmailAddress)

Perform Find

How can I get the quotations to be part of the variable? Or inserted the moment the variable is used for searching?

[IdealData]

You need to use the (back slash) character BEFORE the " (quote character) to allow FM to interpret the " as a piece of text and not a directive as it normally would. You also need to enclose this inside ""

Set $var: """

[innodat]

You saved my day, thank you!

[comment]

As you know the address needs to be enclosed in "...", like "[email protected]", for it to return any search results.

No, I don't know that. I believe it's enough to escape the @ character, so that it doesn't act as a find operator.