Email address in a string

KNIME Analytics Platform
1

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.

2

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

1 Like