how to extract part of a text string

[Anonymous]

Hi Community

I need to extract that part of a text string, that is placed left from the '@'

(username@domain.code) - can that be done and how?

//Soren

[aveeeeeee7en]

hi

use this:

subfield(yourfieldname,'@',1) as username

create this field in the back end script. After doing reload use this script In the front end.

Regards

Aviral Nag

[joshabbott]

=left([Field with Email], index([Field with Email], '@') - 1)