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.
Thank you so much for your suggestion! It was working fine...but then I noticed that some of the company names are in all caps. For example, Alaska Airlines would be ALASKA AIRLINES...so alteryx is picking up ALASKA AIRLINES as part of my search for finding only initials. Any suggestions?
Adds the word boundaries and makes the assumption that a name that is initials will only have 3 or 4 letters in it (so CBRE and IBM are strings containing initials, but ALASKA and JP Morgan are not). Won't be fool proof, because it will still say that something like BEST BUY is a match for initials... But I'm not sure you can get it more narrowed down than that.
Hope that helps weed out at least a few more though! :)