MBS FileMaker Plugin Example Databases

RegEx Find all matches in text

All examples are included with download of MBS FileMaker Plugin.

RegEx Find all matches in text.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts1
Value Lists0
Custom Functions0
Custom Menus33
File Options
Default custom menu set[Standard FileMaker Menus]
When opening file
Minimum allowed version12.0
Login usingAccount Name; Account= Admin
Allow user to save passwordOff
Require iOS passcodeOff
Switch to layoutOff
Hide all toolbarsOff
Script triggers
OnFirstWindowOpenOff
OnLastWindowCloseOff
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
RegEx Find all matches in text
5 fields defined, 4 records
RegEx Find all matches in text

Fields

Table Name: RegEx Find all matches in text - 5 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
TextNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      SearchPatternNormal, TextAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
          Result ListNormal, TextAuto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: German
              Return Whole MatchNormal, NumberAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                  CommentNormal, TextAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German

                        Layout Objects: RegEx Find all matches in text

                        Regular Fields

                        Field Name: RegEx Find all matches in text::Text
                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                        • Top: 78 pt
                        • Left: 42 pt
                        • Bottom: 302 pt
                        • Right: 469 pt
                        • Anchoring: Left, Top
                        Field Format:
                        • Edit Box
                        Field Behavior:
                        • Allow field to be entered: In Find mode, In Browse mode
                        • Touch keyboard type: System Default
                        • Go to next field using: Tab key
                        Yes

                        Field Name: RegEx Find all matches in text::SearchPattern
                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                        • Top: 24 pt
                        • Left: 138 pt
                        • Bottom: 38 pt
                        • Right: 391 pt
                        • Anchoring: Left, Top
                        Field Format:
                        • Edit Box
                        Field Behavior:
                        • Allow field to be entered: In Find mode, In Browse mode
                        • Touch keyboard type: System Default
                        • Go to next field using: Tab key
                        Yes

                        Field Name: RegEx Find all matches in text::Result List
                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                        • Top: 78 pt
                        • Left: 540 pt
                        • Bottom: 302 pt
                        • Right: 961 pt
                        • Anchoring: Left, Top
                        Field Format:
                        • Edit Box
                        Field Behavior:
                        • Allow field to be entered: In Find mode, In Browse mode
                        • Touch keyboard type: System Default
                        • Go to next field using: Tab key
                        Yes

                        Field Name: RegEx Find all matches in text::Return Whole Match
                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                        • Top: 42 pt
                        • Left: 174 pt
                        • Bottom: 56 pt
                        • Right: 253 pt
                        • Anchoring: Left, Top
                        Field Format:
                        • Edit Box
                        Field Behavior:
                        • Allow field to be entered: In Find mode, In Browse mode
                        • Touch keyboard type: System Default
                        • Go to next field using: Tab key
                        Yes

                        Field Name: RegEx Find all matches in text::Comment
                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                        • Top: 306 pt
                        • Left: 138 pt
                        • Bottom: 320 pt
                        • Right: 391 pt
                        • Anchoring: Left, Top
                        Field Format:
                        • Edit Box
                        Field Behavior:
                        • Allow field to be entered: In Find mode, In Browse mode
                        • Touch keyboard type: System Default
                        • Go to next field using: Tab key
                        Yes

                        Group Buttons

                        Button PropertiesCoordinatesScript/Script Step
                          Type:
                        • Text: Find All Matches
                          Additional Properties:
                        • Change to hand cursor over button
                        • Rectangular
                        • Top: 18 pt
                        • Left: 420 pt
                        • Bottom: 43 pt
                        • Right: 535 pt
                        • Anchoring: Left, Top
                        Perform Script [ “Run” ]

                        Scripts:


                        Script Hierarchy

                        Run

                        Script NameRun
                        Run script with full access privilegesOff
                        Include In MenuYes
                        Layouts that use this script
                        Scripts that use this script
                          Script Definition
                          Script Steps
                          • Set Variable [ $regex; Value:MBS("RegEx.Compile"; RegEx Find all matches in text::SearchPattern; 512+1) ]
                          • If [ MBS("isError") ]
                          • Show Custom Dialog [ Title: "Regex Error"; Message: $regex; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ]
                          • Exit Script [ ]
                          • End If
                          • Set Field [ RegEx Find all matches in text::Result List; MBS("RegEx.FindMatches"; $regex; RegEx Find all matches in text::Text; 0; RegEx Find all matches in text::Return Whole Match) ]
                          • Set Variable [ $r; Value:MBS("RegEx.Free"; $regex) ]
                          Fields used in this script
                          Scripts used in this script
                            Layouts used in this script
                              Tables used in this script
                              Table occurrences used by this script
                              Custom Functions used by this script
                                Custom menu set used by this script

                                  Download example: RegEx Find all matches in text

                                  Used functions:




                                  Links
                                  MBS Xojo Plugins