pagenumbers_condensed_with_dashes ( input ; flag_series )

Condensing comma-separated lists of page-numbers with dashes

Average rating: 4.2 (34 votes) Log in to vote

Jens Teich - Show more from this author
DJTO
http://jensteich.de

Sample input:

pagenumbers_condensed_with_dashes("15, 16, 18, 19, 20, 21, 25" ; 0)

Sample output:

15-16, 18-21, 25

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

Let([

list = Substitute( input ; ", " ; "¶" ) ; 
first = GetValue( list ; 1 ) ; 
zfirst = GetAsNumber(first) ;
zsecond = GetAsNumber( GetValue( list ; 2 )) ;
flag_continues = If( zsecond = zfirst +1 ; 1 ; 0 ) ;
rest = MiddleValues( list ; 2 ; 1000000 ) ];

If( flag_series and flag_continues ; "" ; first ) &

Case(
flag_series and flag_continues ; "" ;
IsEmpty( rest ) ; "" ;
flag_continues ; "-" ;
", " ) &

If( IsEmpty( rest ) ; "" ; pagenumbers_condensed_with_dashes(  rest ; flag_continues ))

)

The second parameter is only required for internal purposes and is always zero when calling the function.

Comments

		Ian Renwick, Melbourne Australia Jan 14, 2015
I had almost 3000 products many with multiple page references. I needed to make an index for a catalog. This worked perfectly for my requirements, e.g 202, 203, 204, 205, 206, 207, 208, 209, 210, 211 became 202-211 162, 163, 164, 165, 364, 365 became 162-165, 364-365 Brilliant!

		Denham Morgan, Knoxville TN, USA Jul 8, 2015
Nevermind I figured it out.

		Andrea Astolfi, Italy Apr 30, 2018
This function is fantastic. It works fine

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

pagenumbers_condensed_with_dashes ( input ; flag_series )

Comments

Support this website.

Support this website.