TimeFilter ( txt ; i )

Shorten all the times in a textfield to (n)n:nn format

Average rating: 4.3 (27 votes) Log in to vote

Menno van Beek - Show more from this author
Van Beek Zakelijke Software
https://www.vbzs.nl

Sample input:

TimeFilter (
Peter 12-21-2013 5:30:05 AM - 09:10:29 PM
Claus 12-22-2013 8:45:23 PM - 09:11:11 PM
Jacob 12-23-2013 7:30:42 AM - 11:15:38 AM ; "" )

Sample output:

Peter 12-21-2013 5:30 AM - 09:10 PM
Claus 12-22-2013 8:45 PM - 09:11 PM
Jacob 12-23-2013 7:30 AM - 11:15 AM

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

/*
###################
#  TimeFilter function   
#  Author:   
#  Menno van Beek - Van Beek Zakelijke Software - Woerden, the Netherlands
#  Format:
#  TimeFilter ( Text ; i )
#  Parameters:
#  Text    - Textstring with one or more timestrings like nn:nn:nn or n:nn:nn
#  Data type returned:
#  Text	- any nn:nn:nn and n:nn:nn converted to nn:nn and n:nn  
#  Description:      
#  Cuts of the last 2 digits and the 2nd colon of any timestring found in a 
#  text, no rounding is applied.
#  April 22, 2015
###################
*/

Let ( [
	n = i + 1 ;
	c = WordCount ( txt ) ;
	tm = MiddleWords ( txt ; n ; 1 ) ;
	new_tm = Middle ( tm ; 1 ; Length ( tm ) - 
					If ( PatternCount ( tm ; ":" ) = 2 and 
					tm = Filter ( tm ; "0123456789:" ) and 
					( Length ( tm ) = 7 or Length ( tm ) = 8 ) ; 3 ) ) ;
	new_txt = Substitute ( txt ; [ tm ; new_tm ] )
] ;
	If ( n ≥ c ; new_txt ; TimeFilter ( new_txt ; n ) ) 
)

If you have a timetable extracted from a database with some SQL or List(), then useually the times contain the seconds, which are often not significant. This function simply searches the text for the pattern (n)n:nn:nn and if found converts that into (n)n:nn simply by cutting of the last 3 characters.
AM/PM doesn't disturb the function and is disregarded as long as there's a space between it and the seconds.

Comments

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

TimeFilter ( txt ; i )

Comments

Support this website.

Support this website.