Extract output up to a specific character

Hello all!

I’m working on a workflow that extracts our client database from Notion.
The output I’m getting for the owner on Notion is an email ([email protected]) and I was wondering if there was a formula to only extract the first part of the email? So that the output would only be XX and not [email protected]?

Not sure if I’m being super clear :sweat_smile: but if anyone can help that’d be greatly appreciated!


Hi @Barberg

Yes this can be done with the split function. below is a simple example. the second set node shows the thing you need.


Exactly what I was looking for thank you so much!