Using Wildcards in Pattern Count Script Step
I am trying to get the text after certain characters in a text field. the ext that I'm searching for is always different but the pattern is the same. I need to find the text after "1,C" It is always a number followed by a comma and a letter. I have tried the following with no success:
If ( PatternCount ( Collection::Subjects ; "#,@") = 1 ; After ( Collection::Subjects; "#,@"; 1; 0 );"")
Any help with this would be most appreciated.
Wildcards cannot be used in PatternCount, they will be treated as normal characters.
You may need to use either a looping script or a recursive custom function (Requires Filemaker advanced to create and install) to do what you need here.