How can you search for text that contains the inches symbol (") using the Perform Find script step? I have a field that stores items that are measured in inches and my users don't like the idea of having to enter "inches" instead of just the inch symbol.

"

into the search criteria

Thanks for the reply. My problem is that I am using the Perform Find script step and using a variable for my search criteria, something like:

table:fieldname = $variable

It is not possible to use the escape character when your search criteria is a variable. Any thoughts?

You can suffix the variable with the escape character by concactenating it as raybaudi indicated:

table:fieldname = $variable & "" & """ or

table:fieldname = $variable & """

Note that the backslash character itself is escaped so the above suffixes with "

Sorry, but I think I may not be making myself very clear. Here's my issue.

My script sets a variable to a field value, which can contain the a quote (") somewhere within the text field. The quote is used to designate inches. It could look something like the following:

Pillow 10" to 20" Feather Down

I then take this variable and use it in the Perform Find script step. My problem is that whenever the original text field contains the inch symbol (as the one above does) my search comes up empty. Since the variable contains the inch symbol it doesn't ever match any of the field values.

Any ideas on how to get around this?

How about:

Set Variable [ $var ; Value: Substitute ( table:fieldname ; """ ; """ ) ]

Perform Find [ Restore ] <-- criteria: original text field = $var