User Guide Cancel

ListGetDuplicates

 

Description

Returns duplicate items in a list.

Returns

A new list

Category

List functions

Syntax

listGetDuplicates(list,delimiter,ignoreCase,includeEmptyFields)
listGetDuplicates(list,delimiter,ignoreCase,includeEmptyFields)
listGetDuplicates(list,delimiter,ignoreCase,includeEmptyFields)

See also

Other list functions.

History

  • ColdFusion (2025 release): Added the function.

Parameters

Parameter

Description

list

Name of the list object.

delimiter

(String) A string or a variable that contains one. Characters that separate list elements. The default value is comma. If this parameter contains more than one character, ColdFusion processes each occurrence of each character as a delimiter.

ignoreCase

(True/False) If true, the function performs a case-sensitive string search.
includeEmptyFields (True/False) if true, the function ignores blank values in the list.

Example

<cfscript>
list1 = "one,one,ONE,two,three,,four,THREE,FOUR,FIVE,";
newList1 = listgetduplicates(list=list1,delimiter=",",ignorecase=true);
writeoutput(newlist1)
</cfscript>
<cfscript> list1 = "one,one,ONE,two,three,,four,THREE,FOUR,FIVE,"; newList1 = listgetduplicates(list=list1,delimiter=",",ignorecase=true); writeoutput(newlist1) </cfscript>
<cfscript>
	list1 = "one,one,ONE,two,three,,four,THREE,FOUR,FIVE,";
	newList1 = listgetduplicates(list=list1,delimiter=",",ignorecase=true);
	writeoutput(newlist1)
</cfscript>

Output

one,THREE,FOUR

Example ignoreCase=FALSE

<cfscript>
list1 = "one,one,ONE,two,three,,four,THREE,FOUR,FIVE,";
newList1 = listgetduplicates(list=list1,delimiter=",",ignorecase=false);
writeoutput(newlist1)
</cfscript>
<cfscript> list1 = "one,one,ONE,two,three,,four,THREE,FOUR,FIVE,"; newList1 = listgetduplicates(list=list1,delimiter=",",ignorecase=false); writeoutput(newlist1) </cfscript>
<cfscript>
	list1 = "one,one,ONE,two,three,,four,THREE,FOUR,FIVE,";
	newList1 = listgetduplicates(list=list1,delimiter=",",ignorecase=false);
	writeoutput(newlist1)
</cfscript>

Output

one

Example- numeric list

<cfscript>
list1 = "1, 2, 22, 3, 2, 5, 5, 1";
newList1 = listgetduplicates(list=list1);
writeOutput(newlist1)
</cfscript>
<cfscript> list1 = "1, 2, 22, 3, 2, 5, 5, 1"; newList1 = listgetduplicates(list=list1); writeOutput(newlist1) </cfscript>
<cfscript> 
  list1 = "1, 2, 22, 3, 2, 5, 5, 1"; 
  newList1 = listgetduplicates(list=list1); 
  writeOutput(newlist1) 
</cfscript>

Output

2,5,1

Example- dashed list

<cfscript>
list1 = "1-2-22-3-2-5-5-1";
newList1 = listgetduplicates(list=list1, delimiter="-");
writeOutput(newlist1)
</cfscript>
<cfscript> list1 = "1-2-22-3-2-5-5-1"; newList1 = listgetduplicates(list=list1, delimiter="-"); writeOutput(newlist1) </cfscript>
<cfscript> 
  list1 = "1-2-22-3-2-5-5-1"; 
  newList1 = listgetduplicates(list=list1, delimiter="-"); 
  writeOutput(newlist1) 
</cfscript>

Output

2-5-1

Example- includeemptyfields=true

<cfscript>
list1 = "one,one,ONE,two,three,,,four,THREE,FOUR,FIVE,";
newList1 = listgetduplicates(list=list1,delimiter=",",ignorecase=true,includeemptyfields=true);
writeOutput(newlist1)
</cfscript>
<cfscript> list1 = "one,one,ONE,two,three,,,four,THREE,FOUR,FIVE,"; newList1 = listgetduplicates(list=list1,delimiter=",",ignorecase=true,includeemptyfields=true); writeOutput(newlist1) </cfscript>
<cfscript>
  list1 = "one,one,ONE,two,three,,,four,THREE,FOUR,FIVE,";
  newList1 = listgetduplicates(list=list1,delimiter=",",ignorecase=true,includeemptyfields=true);
  writeOutput(newlist1)
</cfscript>

Output

one,,THREE,FOUR

Get help faster and easier

New user?