Duplicate alphanumeric numbers

[muthum3095159]

Hello Adobe Users,

Hope you are doing well.

I'm reaching out for searching 'Duplicate Serial Numbers' within PDF document that holds 4500 serial numbers (each of them is 12 digit Alpha Numeric).

Adobe need to pick up each of them and finds any duplicate Serial Numbers are present on the document.

Can Adobe search for 'Duplicates' on its contents; Pick a 'String' from the document and search for duplicates.

Many thanks in advance for your time.

Best Wishes

M.Muthu

[try67]

It can, yes, but it requires using a script and that is limited in what it can do. How big are your files?

[muthum3095159]

Hello Try67,

Thanks for getting back to me.

The file size is 267kB. 

Did you mean writing a program (customized) to find 'duplicate SN';  My knowledge on Acrobat is mid-level and not aware of Scripting; If that is easy to do, I will try it. Any link to scripting is appreciated.

[Thom Parker]

The only way to do exactly what you want is to create a custom program. But if you are not above copying the text and pasting it into another tool, then there are some ways to do this built into Acrobat. And there are some free tools. 

1) The standard Search feature  

2) The standare Find feature

3) The Redaction Search (including custom formats)

https://blogs.adobe.com/acrolaw/2011/05/creating_and_using_custom_redact/

4) The free search and highlight Action, which you'll find here:

https://acrobatusers.com/actions-exchange/

[muthum3095159]

Thanks Thom_Parker.

I'm unsure of custom coding and relied on exporting to excel file and used 'Conditional Formating' to find duplicates; Unfortunately the exported data on excel file ended up with some cells merged (multiple Serial Numbers on one cell) and thus excel could not find any duplicate SN.

I'm curious to find any user-friendly tools to help me out; moving myself away from coding.

Thanks for your assistance.

[try67]

I meant more how many pages/words there are in it...

[muthum3095159]

Hello Try67

There are 90pages on the PDF document.

[try67]

That is borderline for a script... If you're interested in hiring someone to create it for you feel free to contact me privately via [try6767 at gmail.com] to discuss it further.

[muthum3095159 · Accepted solution]

Hello Try67

I have figured out a simple solution that works through three steps.

1. Copy & paste to Excel;

2. Text to colums; 

3. Conditional formatting.

It works and I'm happy for the result.

Eventhough it is indirect method (not performed on Acrobat), requirements are met (finding duplicate SN).

Thanks for your time and intent for resolving this issue.

Best Wishes