Brian Dunning's FileMaker Custom Functions

TextFindTimeValues ( TextToSearch ; ValuesFound )

Returns a Value List of Times Found in a String.

  Average rating: 4.7 (26 votes) Log in to vote

Hal Gumbert   Hal Gumbert
CampSoftware
http://www.campsoftware.com

Share on Facebook Share on Twitter

  Sample input:
Input 1: TextFindTimeValues ( "1/7/2012 7am Breakfast at Tiffany's; Meet outside." ; "" )

Input 2: TextFindTimeValues ( "1/5/2012 10am Call Hal to confirm the 1:15pm appointment." ; "" )
  Sample output:
Output 1: "7am"

Output 2: "10am¶1:15pm"

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

TextFindTimeValues ( TextToSearch ; ValuesFound )

Hal Gumbert, CampSoftware.com

Returns a Value List of Times Found in a String.

Parameters:
TextToSearch = the text to search
ValuesFound = used to track found values

Return Value:
A Value List of Found Values

Input: TextFindTimeValues ( "1/7/2012 7am Breakfast at Tiffany's; Meet outside." ; "" )
Output: "7am"

Input: TextFindTimeValues ( "1/5/2012 10am Call Hal to confirm the 1:15pm appointment." ; "" )
Output: "10am¶1:15pm"

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.