Newest functions Upload a function Leave a tip My account

There are 2,638 functions in this library.

CountMultipleValues ( sourceList ; output )

Summarize a list into ValueAx2,ValueB,ValueCx3

  Be the first to rate this function Log in to vote

RealGrouchy - Show more from this author https://realgrouchy.blogspot.com

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

/* CountMultipleValues ( sourceList ; output ) by RealGrouchy. Posted to Brian Dunning's website 2026-04-15 **This depends on the custom function ExcludeValues ()** 2018-10-11: Recursive function to convert a list of values into a count, e.g. turn CountMultipleValues ( "A¶B¶B¶C¶C¶C¶D" ; "" ) into "A,Bx2,Cx3,D" */ Let ( [ /* Configure multiplier and separator symbols */ multiplierSymbol = "x" ; separatorSymbol = "," ; /* Convert the list to uppercase for consistency and attempt to remove blanks. Sorting doesn't work with blank values */ theList = Upper ( SortValues ( Substitute ( sourceList ; [ "¶¶" ; "¶" ] ) ) ) ; firstValue = GetValue ( theList ; 1 ) ; firstValueCount = ValueCount ( FilterValues ( theList ; firstValue ) ) ; remainingList = ExcludeValues ( theList ; firstValue ) ; output = If ( IsEmpty ( output ) ; "" ; output & separatorSymbol ) & firstValue & If ( firstValueCount > 1 ; multiplierSymbol & firstValueCount ; "" ) ] ; If ( ValueCount ( remainingList ) ; CountMultipleValues ( remainingList ; output ) ; output ) ) Click to copy

This is a recursive function I built in 2018 to convert a list of values into a count,
e.g. turn CountMultipleValues ( "A¶B¶B¶C¶C¶C¶D" ; "" ) into "A,Bx2,Cx3,D"

The multiplier symbol ("x" above) and the separator symbol ("," above) can be easily customized.

The use case was that I had a list of ticket purchases (tickets A, B, C, and D) and I wanted a compact way to display in the footer of the printed ticket list how many of each type of ticket I'd need to have on hand.

 

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 22 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: