extract

[master_student]

Hello Guys,

I need to extract the expression before the @, Any idea how :

rymom.golmri@xxxx.tn

Thanks a lot

[sunny_talwar]

May be this

SubField(Field, '@', 1) as UserID

[Anil_Babu_Samineni]

Or this?

=Left(FieldName,Index(FieldName,'@')-1)