Start a new topic

How to remove punctuation from fuzzy matches?

Sometimes you get a fuzzy match that's almost perfect, except for a difference in punctuation:


Screen%20Shot%202016-10-09%20at%2010.15.23.png


With the attached macro you can remove the punctuation via CTRL+ALT+.


Then you'll get:


Screen%20Shot%202016-10-09%20at%2010.16.07.png



(I'm currently looking for a way to get the ‘ removed too. And of course, the double space could be removed too. Just another command in the macro.)



Okay, I've solved it. Also added a line to adjust end punctuation and replace 2 or more consecutive spaces with one space. Please use the attached updated version of the macro.

Screen%20Shot%202016-10-09%20at%2010.48.38.png


I've updated it, e.g. to remove numbers and round brackets too. Used it today many times, and I'm having fun with it.

Login to post a comment