This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
My source data is messy. Due to variations and errors, a single company may have multiple names.
I have copied an example -- Scientific Atlanta. Is there an simple/elegant way to reduce this to 1, w/o having to type an expression for each potential scenario? (Ignore the #s at the end of each row. This is the sound of records for each name variation and is irrelevant.)
I tried using the Fuzzy Match tool. I have 72 input records of a company. There are multiple variations of the company's name. The Fuzzy Match tool outputted 3,249 records (set to output match score). Help?