Create a Distinct List - Remove Duplicates in a List
Home
Create a Distinct List - Remove Duplicates in a List
Remove duplicates from a list to find the unique list members.
Delimiter:
Comma
New line
Remove http://www. and http:// from each entry
Remove trailing slash (/)
Force to lower case
Add commas after each item
List of email addresses
Add single quote symbols (eg. 'item 1','item 2')
Remove quotes and double quotes
Force to Title Case (1st letter capitalized)
Generate INSERT statements:
Table:
Field 1:
Field Value = From list items
Field 2:
Field Value 2:
Input List:
http://www.abc.com/ http://www.def.com/ http://ghi.com/ http://www.abc.com/ http://www.abc.com/ http://ghi.com/ http://www.abc.com/ http://www.abc.com/
Process List
0
List item(s)
Result: