deDup ( )
Function stats
Average user rating
Support
FileMaker 7.0 +
Date posted
04 December 2009
Last updated
02 March 2011
Version
2.0 + View history
Recursive function
Yes
Function overview
Prototype
deDup (
text; separator )
Parameters
text The text that you would like to de-duplicate
separator The text that separates text items
Description
Tags: unique values remove duplicates deduplicate de-duplicate
De-duplicates text which is separated by a delimiter - e.g. you might have a value list that needs de-duplicating.
Reviewing this now - this might only work for valueLists - think you will need to change first part of Let function to deal with non-value list text... haven't tested. Will test one day & update.
Examples
Sample input
deDup( List( table::field ) ; ¶ )
Sample output
This will give you a list will all the duplicates removed
Function code
Let(
[
text = Substitute( text ; [ separator ; ¶ ] ) ;
value = GetValue( text ; 1 ) ;
count = ValueCount( text ) ;
sep = "@|$|@" ;
text = Replace ( Substitute ( ¶ & text & ¶ ; [ ¶ ; ¶ & sep ] ; [ sep & value & ¶ ; "" ] ; [ sep ; "" ] ) ; 1 ; 1 ; "" ) ;
next = If( count > 0 ; deDup( Replace( text ; Length( text ) ; 1 ; "" ) ; separator ) )
] ;
If( count > 0 ; value & If( Length( next ) > 0 ; separator & next ) )
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/235
Prototype: deDup( text; separator )
Function Author: Charlie (http://www.fmfunctions.com/mid/132)
Last updated: 02 March 2011
Version: 2.0
*/
// ===================================
[
text = Substitute( text ; [ separator ; ¶ ] ) ;
value = GetValue( text ; 1 ) ;
count = ValueCount( text ) ;
sep = "@|$|@" ;
text = Replace ( Substitute ( ¶ & text & ¶ ; [ ¶ ; ¶ & sep ] ; [ sep & value & ¶ ; "" ] ; [ sep ; "" ] ) ; 1 ; 1 ; "" ) ;
next = If( count > 0 ; deDup( Replace( text ; Length( text ) ; 1 ; "" ) ; separator ) )
] ;
If( count > 0 ; value & If( Length( next ) > 0 ; separator & next ) )
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/235
Prototype: deDup( text; separator )
Function Author: Charlie (http://www.fmfunctions.com/mid/132)
Last updated: 02 March 2011
Version: 2.0
*/
// ===================================
Login or register to comment
Create a new account with fmcustomfunctions.com or login to post a comment.
