User Profile
DellMachine
Copper Contributor
Joined Aug 21, 2023
User Widgets
Recent Discussions
How to extract text from a string of text that follows a random pattern
Hi All, Newbie here . I have an Excel sheet with over 50k rows. I am trying to extract Merchant names from the Transaction ID. Since the Transaction ID doesn't follow any specific patterns I am not able to use the std. if/search. Please refer the below table for reference. Thanks, appreciate all your help. Transaction ID Return Value= Merchant Name CColaUK_121324 CocaCola CoCola UK*124214 CocaCola Pepsi USA Pepsi PepcXCDA_ 12346789 Pepsi Prime * ACREFEDF Prime Dr. Pep8423049283 Dr Pepper http://www.Diethttp://pepsi.com/ Pepsi FantaQWOERT Fanta DrPepper_DFSDF MountainDew*121314324EWR Sprite_GDFGHDFG Diet Pepsi_1243124 Coke Zero_3459458738491.1KViews0likes1Comment
Recent Blog Articles
No content to show