Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Data Detectors for FileMaker


Recommended Posts

  • Advertiser


DataDetector.pngYou may have seen Safari, Mail, Notes or other applications highlighting information in some text and they may offer to do something with the data, e.g. take a date and make a new event in your calendar or take an address and add it to your contacts.

Have you wondered how this works? 

Apple provides data detectors in their frameworks to identify those data bits. We just added a new function RegEx.DataDetector to use those in FileMaker. While you can do a lot with regular expressions yourself, these pre-built detectors are convenient to use as they are. Here is our new function:

MBS( "RegEx.DataDetector"; CheckingType; Text )  

You tell what to look for, either Date, Address, Link, PhoneNumber or TransitInformation. You can combine those types and look for multiple things together. The plugin then uses Apple's framework and returns the result as JSON for you to inspect. Let's take an example:

MBS( "RegEx.DataDetector"; "PhoneNumber"; "Phone us at (123)456-789 later!" )

With this result:

    "length" : 12,
    "position" : 13,
    "text" : "(123)456-789",
    "type" : "PhoneNumber",
    "PhoneNumber" : "(123)456-789"

As you see we have a JSON array with results. Each result has always the text found with the position and length to define the range in the original text. Then we provide the type of item found and type specific information. For a phone number this is simply an entry PhoneNumber with the number. If you need to format the phone number, check Using libPhoneNumber for phone number formatting. For an address, you may see Name, JobTitle, Organization, Street, City, State, ZIP and Country listed. Date results come with date, time zone and duration while links comes with an URL.

So next time you have to code something and have some text to analyze, this function may 

Please try those functions now with version 11.1pr5 of MBS FileMaker Plugin and let us know how they work for you.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use