Brian Dunning's FileMaker Custom Functions

DeleteDuplicatesList ( listOfValues )

Delete all duplicate values from a list.

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

HAZI   HAZI
none
http://hazisarashi.com/

Share on Facebook Share on Twitter

  Sample input:
ListOfUniq ( "AAA¶BBB¶CCC¶AAA¶DDD¶CCC" )
  Sample output:
"BBB¶DDD"

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

none

 

Comments

caps   caps, Portugal
Feb 25, 2012
This functions isn't working properly, developer please test with this values:
1.
"Jon"& "¶" &
"Jon"& "¶" &
"Jon"& "¶" &
"Jon"& "¶" &
"Jon"& "¶" &
"Jon"& "¶" &
"Jon"& "¶" &
"Rosen"& "¶" &
"Rosen"& "¶" &
"Rosen"& "¶" &
"Rosen"& "¶" &
"Jon"& "¶" &
"Jon"& "¶"

No result

2.
"AAA"&"¶"&
"BBB"&"¶"&
"AAA"&"¶"&
"AAA"&"¶"&
"AAA"&"¶"&
"AAA"

Result: "BBB", where is "AAA".
This isn't working with same values greater than 2.
"AAA"&"¶"&
"BBB"&"¶"&
"BBB"&"¶"&
"BBB"&"¶"
Result is "AAA" without "BBB"
 
HAZI   HAZI, Japan
Feb 26, 2012
Thank you for comment.

1.
Here is not only duplicate values. So, no data comes back.
Is this correct.

2.
> Result is "AAA" without "BBB"

I tried.
Result is "BBB¶AAA ;"
Do the same as the result of me?

If you have a different result, you should have something wrong.
 

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.