Re: [WebDNA] Finding duplicate emails in a large database

This WebDNA talk-list message is from

2016

It keeps the original formatting. numero = 113268
interpreted = N
texte = 856--Apple-Mail=_B6AD89CA-58E0-4922-90DB-6B749B910844Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiSome old code I had to do just that[math show=3Df]linecount=3D0[/math][Text]prevrecord=3Dnoemailaddress[/Text][Search =db=3D^data/customers.db&neIDdata=3Dfind_all&neEMAILdatarq=3D[blank]&asEMAI=Lsort=3D1][FoundItems][HideIf [email]=3Dnone][ShowIf [URL][EMAIL][/URL]=3D[URL][prevrecord][/URL]][math show=3DF]linecount=3D[linecount]+1[/math][/ShowIf][Text]prevrecord=3D[email][/Text][/HideIf][/FoundItems]

There are [numfound] total =customer records
Following is a list of duplicate =emails, click on 'show details' to manage the records
	[email]	show= details=20

[/Search]

TOTAL DUPLICATE RECORDS FOUND =3D [linecount]

Kind regardsStuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.au> On 22 Dec 2016, at 03:36, Tom Duke wrote:>=20> Hi all,>=20> Can anyone advise me on the most efficient way to search for records =with duplicate emails in a large database?>=20> - Tom>=20>=20> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us--Apple-Mail=_B6AD89CA-58E0-4922-90DB-6B749B910844Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-asciiSome old code I had to do just that

[math show=3Df]linecount=3D0[/math]

[Text]prevrecord=3Dnoemailaddress[/Text]

[Search =db=3D^data/customers.db&neIDdata=3Dfind_all&neEMAILdatarq=3D[blank=]&asEMAILsort=3D1]

<TABLE border=3D"0" cellpadding=3D"2" cellspacing=3D"0" =width=3D"700">

<TR =bgcolor=3D"009900">

<TD colspan=3D4><SPAN= class=3D"whitetext">There are [numfound] total customer =records</SPAN></TD></TR>

<TR>

<TD =colspan=3D"4" align=3D"center">Following is a list of duplicate =emails, click on 'show details' to manage the =records</TD>

</TR>

<TR><TD =colspan=3D4><HR></TD></TR>

[FoundItems][HideIf =[email]=3Dnone]

[ShowIf =[URL][EMAIL][/URL]=3D[URL][prevrecord][/URL]]

[math =show=3DF]linecount=3D[linecount]+1[/math]

<TR [showif =[linecount]\2]bgcolor=3D"CCCCCC"[/showif]>

<TD =width=3D"30%">&nbsp;</TD>

<TD =width=3D"20%" align=3D"right">[email]</TD>

<TD width=3D"20%">

<a =HREF=3D"dedupe02_customers_detail.html?email=3D[URL][email][/URL]">show= details</A> 

</TD>

<TD width=3D"30%">&nbsp;</TD>

</TR>

[/ShowIf]

[Text]prevrecord=3D[email][/Text][/HideIf]

[/FoundItems]

</TABLE>

[/Search]

<H2>TOTAL DUPLICATE RECORDS FOUND =3D =[linecount]</H2>