(We cannot use Zapier Integration). So, I created a Data Shuttle to pull the information from the Zoom attendance report. However, I need to Index/Collect how we designate the entity that they are associated with based on the person that attended, and we don't get the emails of outside parties from the meeting.
People's Zoom names are different almost EVERY month. They have different ways of doing their names (e.g. Name, Client Info; Name - Client Acronym; Name | Full Client Name, on and on). Which means, my overall list of possible attendees to use for the Index/Collect could have 1 person listed 4 times, and then, the next month, it's different AGAIN.
I can separate the first name from the Last Name + extra stuff, but since the # of characters is always different as well as what they are using to divide their name from the extra stuff I can't figure out how to just get their name in order to Index/Collect.
Has anyone developed something that will clean that?
Or, is there a way to partial match that isn't a string of text? B/c I need for the Index/Collect to match the Name without all of the rest of the stuff to pull something from another sheet.
