I was given an excel file where someone stored all of the information in a single column (var1). I need to pull information but it will be in random orders. Good thing is the person gave the information and then put a period after it. Example of Var1: Type = 2. Size = 4 in x 12 in. Group = ABC grouping. Group = A and B Holdings. Type = 1. Group = Mark H and Company. The variable I need to pull is group. It always starts with "Group = " and has a period in the end. But will be anywhere within the var1 (so you can't name a specific period. Sometimes it may not exist. This variable can be any length in words. I just need to pull the string between "Group = " and the period. This can't be done in excel due to the size of the dataset. I have tried scan, find, splitting at the period, and I am not sure what to do at this point to organize it.
... View more