Find option

[Mathenay Lankou]

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.

[guy038]

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