Re: bug in the PatternCount function?
- From: Howard Schlossberg <howard@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 08 Dec 2007 22:31:41 -0800
The backslash is acting as an escape character for the quote. So if you had "\"", you would actually end up with a quote as a result (in your case, as the patterncount search character). If what you want is the slash as your patterncount search character, then try it as "\\", which escapes the slash with a slash, leaving a slash result.
Michael Myett wrote:
Hello All,
Using FileMaker 9.0v3 Advanced on Win XP SP2 Media Center Edition
Using a simple PatternCount formula as follows,
PatternCount(somefield;"\")
I receive the following error when trying to close out of the calculation dialog, "This text constant does not end with a quotation mark."
All other text operators and special characters work fine in the same formula. However, if I replace the hard coding with a global field which holds the backslash the formula works perfectly. It is just the backslash, I have tested all the other characters.
I guess this could be a problem with my system or file corruption. So I was hoping to find out if anyone else has had this problem, before I report it to FileMaker as a bug.
Thanks,
M Myett
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles
FileMaker 8 Certified Developer
Member, FileMaker Business Alliance
.
- Follow-Ups:
- Re: bug in the PatternCount function?
- From: Michael Myett
- Re: bug in the PatternCount function?
- References:
- bug in the PatternCount function?
- From: Michael Myett
- bug in the PatternCount function?
- Prev by Date: bug in the PatternCount function?
- Next by Date: Re: bug in the PatternCount function?
- Previous by thread: bug in the PatternCount function?
- Next by thread: Re: bug in the PatternCount function?
- Index(es):
Relevant Pages
|
|