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