Iterate an input

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?

You can use an Iterator module with the built-in function split

E.g.:

{{ split(1.text; ";") }} 
2 Likes

thanks a lot… its working

2 Likes