2 Replies Latest reply on Oct 22, 2012 10:04 AM by philmodjunk

    Wildcard PatternCount search



      Wildcard PatternCount search


                Good morning. I have a global field that gets information from web source code. Would someone know how to find the following test string in a PatternCount script step it the numbers are different in every reocord?


                I have tried


                but that returns nothing.Same result with


                The web page does have characters like * and # . And I notice when I do a search with any kind of wildcard character it returns nothing. Thanks


        • 1. Re: Wildcard PatternCount search

               What happnes if you remove the literal quotation marks from either end?

          • 2. Re: Wildcard PatternCount search

                 Wildcards are not supported by the PatternCount function.

                 You could use:

                 PattternCount ( yourText ; "ref=ntt_athr_dp_pel_" )

                 But that won't work if there are instances of ref=ntt_athr_dp_pel_ that do not have the number and that thus need to be excluded from the count.

                 If you have FileMaker Advanced, you might search one of the custom function web sites to find a custom function you can add that provides the text searching capabilities that you want.