SumUniqueText ( Field ; TotalLines ; StartLine ; Text ; Delimiter )

Produces a list of all the unquie values in a set of data

Average rating: 4.4 (29 votes) Log in to vote

Simon Ward - Show more from this author
Linear Blue
http://www.linearblue.com

Sample input:

SumUniqueText ( Field ; count(field) ; 1 ; "" ; ", " )

Field vlaues
text1
text1
text2

Sample output:

text1, text2

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

Case(TotalLines > 0 ; 

Let ( [

Check = Text ; 
Data =   GetNthRecord ( Field ; StartLine ) ; 
Value = Case(PatternCount ( Delimiter & Check & Delimiter ; Delimiter & Data & Delimiter ) > 0 ; "" ; Data );

Output = Case ( StartLine = 1 ; Value ; Text & Case(Value = ""  ; "" ; Delimiter) & Value ) ] ;

Case(TotalLines = StartLine ; Output ; SumUniqueText (Field ; TotalLines ; StartLine + 1 ; Output ; Delimiter ))

))

Finds all the unquie values from a list of data either in the found set or from a portal. List is separated by defind delimiter.

Comments

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

SumUniqueText ( Field ; TotalLines ; StartLine ; Text ; Delimiter )

Comments

Support this website.

Support this website.