+ Reply to Thread
Results 1 to 4 of 4

Find the Strings Common In All TXT Files Within a Folder

  1. #1
    Forum Contributor
    Join Date
    07-22-2013
    Location
    london
    MS-Off Ver
    Excel 2013
    Posts
    133

    Find the Strings Common In All TXT Files Within a Folder

    Please see attached zip. (there is no excel sample this time because there is nothing to show)
    It contains a folder named "sample files folder" with 10 TXT files, named 1 to 10.
    Each file has around 60k characters written in solidity language.

    Were looking to find the strings common in all the TXT files and ranked them in an Excel column by character length.
    In other words, each string found should be present every single TXT file.

    How do we do it?
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: Find the Strings Common In All TXT Files Within a Folder

    How you define string in context of the files in archive? Is it a part of text finishing with \r\n? Wow about start/finish parts where you have LF used for separation of consequtive lines?

    And why use Excel for that task?
    Best Regards,

    Kaper

  3. #3
    Forum Contributor
    Join Date
    07-22-2013
    Location
    london
    MS-Off Ver
    Excel 2013
    Posts
    133

    Re: Find the Strings Common In All TXT Files Within a Folder

    IDK. I knew this one was hard.
    The files are responses from API, probably in JSON.
    We need to find common items in all of them to fast sniff/verify future versions.

    Thought that it could be done in Excel.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: Find the Strings Common In All TXT Files Within a Folder

    As for the text compare on a large scale I'd rather go for python solutions.
    And As I said - to try with excel one shall know what shall be treated as strings. What is (are) the delimiter(s) between strings in the files.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Search all files in folder for numerous strings
    By marcosis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2020, 04:07 AM
  2. [SOLVED] Get Value In Between Strings From All Text Files In Folder
    By exc4libur in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2016, 07:25 PM
  3. Moved to commercial services forum.
    By Midnight-Oil in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-28-2015, 01:05 PM
  4. Help searching an array of text strings for common strings
    By ABComp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-23-2012, 11:19 PM
  5. Comparing sets of strings to find the latest file in a folder
    By Dunctonsteel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2012, 03:46 AM
  6. Find common characters in multiple strings
    By amient2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2009, 04:54 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1