Brian Dunning's FileMaker Custom Functions

UniqueList ( ListA ; CaseSensitive )

Unique data in a list

  Average rating: 4.5 (43 votes) Log in to vote

Agnes Barouh   Agnes Barouh
Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html

Share on Facebook Share on Twitter

  Sample input:
UniqueList ( "One¶Two¶three¶two¶One ; "" or 0 )

--------------------
UniqueList ( "One¶Two¶three¶two¶One ; 1 )
  Sample output:
One¶Two¶three


-------------


One¶Two¶three¶two

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

Not recursive Function - Optional Parameters : Case Sensitiveness ( boolean format or null )


* UniqueList () requires CustomList ( start ; End ; Function )
http://www.briandunning.com/cf/868


----------------------------------------- more détails

--------- CaseSensitive = empty or 0

UniqueList ( "One¶Two¶three¶Four¶five¶ONE¶two¶four¶five¶Seven" ; "" or 0 )
-> Result = "One¶Two¶three¶Four¶five¶Seven"

--------- CaseSensitive = 1

UniqueList ( "One¶Two¶three¶Four¶five¶ONE¶two¶four¶five¶Seven" ; 1 )
-> Result = "One¶Two¶three¶Four¶five¶ONE¶two¶Seven"

 

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.

Under construction. Email me your wish list for improvements.