PatternCount()

Category: Text

Syntax: PatternCount ( text; searchString )


Parameters:

textAny expression that resolves to a text string.

searchStringAny expression that resolves to a text string, representing the substring for which you want to search within the text string.

Data type returned: Number

Description:

Returns the number of times that searchString appears in the text string. PatternCount() returns 0 if the searchString is not found.

Only non-overlapping occurrences of searchString are counted by PatternCount(). PatternCount() is not case sensitive.

Even though PatternCount() is designed to answer the question "how many?", it is often used simply to determine whether one string is contained within another. If it returns any value other than zero, the search string is found.

Examples:

Function

Results

PatternCount ("This is a test"; "is")

Returns 2.

PatternCount (WindowNames; "¶") + 1

Returns the number of carriage returns in the list returned by the WindowNames() function. This could be used to determine the number of windows that are available. The ValueCount() function could also be used for this purpose.

PatternCount ("abababa"; "Aba")

Returns 2.




: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information

show all menu



FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352
Similar book on Amazon

Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net