Find option



  • I have to compare a lot of strings and keep only distincts strings.
    No problem if there are many identical strings but sometimes I encounter a string that is nearly the same.
    My question : I propose to have a compare string option that gives for each string the percent of identical parts;

    Example:

    France
    Table
    Street
    England
    StreetView

    and we search for “Street”, so the result would be

    France 0%
    Table 0%
    Street 100%
    England 0%
    StreetView 50%

    I have to use this for finding similar streets. After I have to change the similar streets with the unique string. It is for having an index in a database.



  • Hello, @mathenay-lankou and All,

    Here is a regex solution :

    • Open your list of strings. For instance :
    France
    Table
    Street
    England
    StreetView
    
    • Open the Replace dialog ( Ctrl + H )

      • SEARCH (?-is)^(Street)$|(.*(?1).*)|(.+)

      • REPLACE $0(?1 100%)(?2 50%)(?3 0%)

      • Tick the Wrap around, preferably

      • Select the Regular expression search mode

      • Click on the Replace All button

    => You should get the expected list, below :

    France 0%
    Table 0%
    Street 100%
    England 0%
    StreetView 50%
    

    If I’m on the right way, I’ll explain you the regex details, next time ;-))

    Best Regards,

    guy038


Log in to reply