Splitting email address in CC

Lavanya

Hi,

I need to split email address and store first part in a user field. How can we achieve this in Config console.

Thanks

andy

You can likely use the "split on" type operator and split by the "@" symbol.

There may be a better way to accomplish this, but you could do something like this...

EmailSplit is a DerivedField
    type is Alpha size 30
    for each EmailAddress split on "@"
        if(EmailSplit = "")
            EmailSplit = each
    return EmailSplit