Check for Duplicates

Check for Duplicates

For

From

Reddit

Status

Broken

Formulas

Share

Has Duplicates

Duplication Check

Name

Entries

Total

Unique

Has Duplicates

Entries

Name

Check Duplicates

Has Duplicates


prop("Total") != prop("Unique")

Is Duplicate

Duplication Check

Name

Entries

Check Duplicates

This is a title

This is another title

This is another title

Title with some numbers 123

Title with some numbers 123

Entries

Name

Check

Is Duplicate

Column

Check Duplicates

123456789

Check Duplicates

OneTwoThree

This is another title

Check Duplicates

Thisisanothertitle

Check Duplicates

123

Check Duplicates

456

Title with some numbers 123

Check Duplicates

Titlewithsomenumbers123

Check Duplicates

123456789

Check Duplicates

onetwothree

This is a title

Check Duplicates

Thisisatitle

This is another title

Check Duplicates

Thisisanothertitle

Check Duplicates

Check Duplicates

OneTwoThree

Title with some numbers 123

Check Duplicates

Titlewithsomenumbers123

Check Duplicates

TestTest

Check Duplicates

Test:Test

Check Duplicates

TestTest

Check Duplicates

Is Duplicate

🔥

As this removes spaces for check the match, something like One Two Three will show as being a duplicate of OneTwoThree.


prop("Name") ? (length(replaceAll(replaceAll(replaceAll(prop("All"), " ", "") + ",", "\b" + replaceAll(prop("Name"), "[ |,]", "") + "\b", "★"), "[^★]", "")) > 1) : false

Duplicate URLs

Duplication Checks

Name

Related to Entries (Tags)

Check Duplicate URLs

Entries

Is Duplicate URL


prop("URL") ? (length(replaceAll(replaceAll(replaceAll(prop("All URLs"), " ", "") + ",", "\b" + replaceAll(prop("URL"), " ", "") + "\b", "★"), "[^★]", "")) > 1) : false

By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!