dispjahr ( sorted ; index )

Collapses a list of sorted year numbers to a more readable format

Average rating: 3.7 (20 votes) Log in to vote

Mathias Drexler
acib GmbH
http://www.acib.at

Sample input:

Dispjahr(
"
2010
2011
2012
2014
2015
"

Sample output:

2010 - 2012, 2014 - 2015

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

//dispjahr (sorted;index)
//index for function call = 1
//sorted = sorted list of year numbers
//Exmample dispjahr(liste(2015;2016;2017;2019;2020);1) = 2015-2017, 2019-2020


SetzeVar (
	[
	n = WörterAnzahl(sorted);
	i = index;
	istjahr = WörterMitte(sorted;i;1);
	vorjahr = WörterMitte(sorted;i-1;1);
	nextjahr = WörterMitte(sorted;i+1;1);
	text = Falls
		(	
		vorjahr +1 = istjahr UND istjahr+1 = nextjahr;"";
		vorjahr +1 = istjahr;" - " & istjahr;
		i=1;istjahr;
		", " & istjahr
		)
	];
	text & Wenn (i<n;dispjahr(sorted;i+1);"")
)

The function collapses a list of sorted year numbers to a more conventional, readable format eliminating years following each other and substituting it with a dash (-). Thereby a long list of years (e.g. generated from single records) ist converted to a readable short expression.

I used it for some accounting purposes, where I have one record per year and wanted to build a list, which years are present.

Comments

		Thomas Hellwig, Hamburg / Germany Jun 11, 2016
Please note: "Function Definition (the function itself): Please use FileMaker's convention of one space between all terms and separators." To edit it please click on the link: This is my Custom Function and I want to edit it

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

dispjahr ( sorted ; index )

Comments

Support this website.

Support this website.