New custom field using substitute of the Username field

Question

I am creating new custom field on user record. The value for the new field is based on the Username field on the user record, but only the text left of the @ sign. For example if Username is . The value for the new field should be john.doe. BTW, the right side is not alway "@ ". If it was I could use -  SUBSTITUTE(Username, "@ ", ""). It could also be something like "@ ". Thanks.

Deepak K Anand · Accepted Answer

Try this -  LEFT(Username, FIND('@', Username) - 1)

Mark Mandrano · Answer

Thank you Deepak, that worked!

New custom field using substitute of the Username field

Data Management

Aprendizaje relacionado

Más ayuda