https://www.fileseek.ca/Discussions/RSS/?TopicID=ceac950d-a2fe-4f31-98f5-f79e8526826c FileSeek RSS: Searching for lists of data in a large file Fri, 17 Apr 2026 01:58:13 GMT en hourly 1 https://www.fileseek.ca/Discussions/RSS/?TopicID=ceac950d-a2fe-4f31-98f5-f79e8526826c https://www.fileseek.ca/Discussions/View/searching-for-lists-of-data-in-a-large-file/?ID=ceac950d-a2fe-4f31-98f5-f79e8526826c#4 Mon, 21 Sep 2015 19:42:32 GMT Binary Fortress Software https://www.fileseek.ca/Discussions/View/searching-for-lists-of-data-in-a-large-file/?ID=ceac950d-a2fe-4f31-98f5-f79e8526826c#4 FileSeek Ok, are there any hyphens separating the characters? ]]> https://www.fileseek.ca/Discussions/View/searching-for-lists-of-data-in-a-large-file/?ID=ceac950d-a2fe-4f31-98f5-f79e8526826c#3 Fri, 18 Sep 2015 20:29:59 GMT Binary Fortress Software https://www.fileseek.ca/Discussions/View/searching-for-lists-of-data-in-a-large-file/?ID=ceac950d-a2fe-4f31-98f5-f79e8526826c#3 FileSeek Yes, the serials are always 7 characters long. Thanks. ]]> https://www.fileseek.ca/Discussions/View/searching-for-lists-of-data-in-a-large-file/?ID=ceac950d-a2fe-4f31-98f5-f79e8526826c#2 Fri, 18 Sep 2015 20:23:05 GMT Binary Fortress Software https://www.fileseek.ca/Discussions/View/searching-for-lists-of-data-in-a-large-file/?ID=ceac950d-a2fe-4f31-98f5-f79e8526826c#2 FileSeek Do the serial numbers follow a specific format? (i.e. NNNN-NNNN-NNNN)? If so, you we can help you build a RegEx string that will find the serial numbers in the file ]]> https://www.fileseek.ca/Discussions/View/searching-for-lists-of-data-in-a-large-file/?ID=ceac950d-a2fe-4f31-98f5-f79e8526826c Thu, 17 Sep 2015 13:55:44 GMT Binary Fortress Software https://www.fileseek.ca/Discussions/View/searching-for-lists-of-data-in-a-large-file/?ID=ceac950d-a2fe-4f31-98f5-f79e8526826c FileSeek I'm new to this program. I often have to search for lists of serial numbers in a large file of several hundred thousand lines, lets say 400K lines. The data I'm searching for can be a few serial numbers or perhaps hundreds of serials. Typically I would have these serials in a separate listing.

I have used Excel doing VLOOKUPS, and have written PowerBasic code to do these searches. But Excel is a bit of a grind setting up the VLOOKUP data, etc. My Power Basic code runs as a single thread, fairly slowly.

Can Fileseek do this easily and quickly?

Thanks, SamG ]]>