How can I compare text with certain characters?

[alexandraPT]

Hi there!

Can give me an help about a problem that i'm having? I hope so. I need to make a comparison between values of text type (for example 13" ). When I'm writing the code in the script, and try to insert the value to make the comparison, an error is generated. For example:

IF (<FieldName> = "13"")

The values are: 13", 14", ... (a proprety of a Monitor)

Can anyone explain me how to solve this problem?

Thanks a lot...

FileMaker Version: 6

Platform: Mac OS X Jaguar

[Fitch]

When using a quote mark in a text string, you have to add another quote mark. Not very intuitive, and in fact this has changed in FileMaker 7. Anyway, your statement would look like this:

IF (<FieldName> = "13""")

Another option would be to use TextToNum(fieldname) = 13 so you could just ignore the quote mark.

Personally, I probably would just make that field a number field in the first place, and not include the inch/quote mark as part of the data -- it's the number that matters here.

[Fitch]

I just realized this was a cross-posted question. Please don't do that, it wastes everyone's time.