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;
and we search for “Street”, so the result would be
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 )
$0(?1 100%)(?2 50%)(?3 0%)
Wrap around, preferably
Regular expressionsearch mode
Click on the
=> 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 ;-))