Can anyone suggest to me an approach for the below situation:
I get data from multiple sources and therefore I get the field Company Name from all these sources. It turned out that in many of the sources this field is a manual input, so I have many different company names that actually refer to the same name, for example I can have:
Company Name Limited Cpn - Name LTD Company Limited Company Name: Limited
Moreover, some of them are even more random, such as:
Sample Name International Limited Sample Name INL Sample Name - INL Sample Name - INL.
Is there any function that I can use to somehow take out the main name of all these, so that I can have only one name for a company instead of multiple?
.png "Former Employee"){kind=icon}
