DeleteDuplicatesList ( listOfValues )

Delete all duplicate values from a list.

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

HAZI
none
http://hazisarashi.com/

Sample input:

ListOfUniq ( "AAA¶BBB¶CCC¶AAA¶DDD¶CCC" )

Sample output:

"BBB¶DDD"

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

/*
DeleteDuplicatesList ( listOfValues )
Delete all duplicate values from a list.
ListOfUniq ( "AAA¶BBB¶CCC¶AAA¶DDD¶CCC" ) -> "BBB¶DDD"
*/

If (
    // new
    listOfValues <> "__NULL__" ;
    Let ([
        // Initialize
        $$_DeleteDuplicatesList_Data = listOfValues ;
        $$_DeleteDuplicatesList_Result = "" ;
        $$_DeleteDuplicatesList_n = 1 ;
        
        // Removing extra line breaks
        $$_DeleteDuplicatesList_Data = "¶" & Substitute ( $$_DeleteDuplicatesList_Data ; [ "¶¶¶¶¶" ; "¶" ] ; [ "¶¶¶¶" ; "¶" ] ; [ "¶¶¶" ; "¶" ] ; [ "¶¶" ; "¶" ] ) & "¶"
    ];
        DeleteDuplicatesList ( "__NULL__" )
    );
    
    // After the second
    If (
        // Loop end
        ValueCount ( $$_DeleteDuplicatesList_Data ) < $$_DeleteDuplicatesList_n ;
        Let([
            _DeleteDuplicatesList_Result = $$_DeleteDuplicatesList_Result ;
            $$_DeleteDuplicatesList_Result = "" ;
            $$_DeleteDuplicatesList_Data = "" ;
            $$_DeleteDuplicatesList_n = ""
        ];
            // return
            _DeleteDuplicatesList_Result
        );
        
        // Loop
        If (
            // Does not contain data for the current row in the $$_ListOfUniq_Result
            PatternCount (
                $$_DeleteDuplicatesList_Data ;
                "¶" & GetValue( $$_DeleteDuplicatesList_Data ; $$_DeleteDuplicatesList_n ) & "¶"
            ) = 1;
            
            // True
            Let([
                $$_DeleteDuplicatesList_Result = List ( $$_DeleteDuplicatesList_Result ; GetValue ( $$_DeleteDuplicatesList_Data ; $$_DeleteDuplicatesList_n ) ) ;
                
                // n + 1
                $$_DeleteDuplicatesList_n = $$_DeleteDuplicatesList_n + 1
            ];
                // Next
                DeleteDuplicatesList ( "__NULL__" )
            );
            
            // False
            Let( [
                // n + 1
                $$_DeleteDuplicatesList_n = $$_DeleteDuplicatesList_n + 1
            ] ;
                // Next
                DeleteDuplicatesList ( "__NULL__" )
            )
        )
    )
)

none

Comments

		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, 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.

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

DeleteDuplicatesList ( listOfValues )

Comments

Support this website.

Support this website.