Brian Dunning's FileMaker Custom Functions

TextFindDateValues ( TextToSearch ; ValuesFound )

Returns a Value List of Dates Found in a String.

  Average rating: 4.9 (24 votes) Log in to vote

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

Share on Facebook Share on Twitter

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

Input 2: TextFindDateValues ( "1/5/2012 Get gift for Hal for his birthday on 1/7/2012." ; "" )
  Sample output:
Output 1: "1/7/2012"


Output 2: "1/5/2012¶1/7/2012"

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

TextFindDateValues ( TextToSearch ; ValuesFound )

Hal Gumbert, CampSoftware.com

Returns a Value List of Dates 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: TextFindDateValues ( "1/7/2012 7am Breakfast at Tiffany's; Meet outside." ; "" )
Output: "1/7/2012"

Input: TextFindDateValues ( "1/5/2012 Get gift for Hal for his birthday on 1/7/2012." ; "" )
Output: "1/5/2012¶1/7/2012"

 

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.