Email address in a string

[aehrenworth]

I have a manual column that someone provided me with hundreds of names and email addresses separated by a space.

For example:

Josh Smith jsmith@company.com
Katyln Mary Scott kmscott@company.com

Because sometimes there could be a middle name, I assume there is a regex function that can parse out the email address here using the location of the @? I can’t seem to figure it out.

[HansS]

Hi @aehrenworth

I’m not so familiar with regex, but you can use a String Manupulation node for this as wel.

To extract the name:
substr($input$,0,lastIndexOfChar($input$,' ' ))

To extract the email adress
strip(substr($input$,lastIndexOfChar($input$,' ' )))

gr. Hans