hi together, i need help.
In hubspot i have a field with a information like this:
KU2MO1#KU2#Online Marketing Manager (m/w/d);KU2MO2#KU2#Online Marketing Manager (m/w/d);KU2MO3#KU2#Online Marketing Manager (m/w/d);KU2MO4#KU2#Online Marketing Manager (m/w/d)
Now i want a kind of iterater that separates the parts between the ;
I only need the KU2MO1 for example, so everything infront of the #
With each of this values i want to search in a google sheet.
how can i do this?