Split text in data field

[former_member338149]

I have a report that is created from a Bex Query. I have an email field that I would like to split into firstname and last name. I tried to look online and in the SCN site for documentation for how to do this. The format on the email field is firstname.lastname@tdsinc.com. I want to split it up into two fields - firstname and lastname,

Some of the searching I have done are below.

Please let me know if you have questions.

[Former Member · Accepted solution]

For FiratName use

=Substr([MailId];1;Pos([MailId];".")-1)

For LastName use

=Substr([MailId];Pos([MailId];".")+1;((Pos([MailId];"@"))-(Pos([MailId];".")))-1)

Where [MailId] is a formula that contains email id

[former_member338149 · Accepted solution]

Thanks. This worked perfectly.

[Former Member · Accepted solution]

Hello Sithara,

Glad it worked you should have marked answer correct rather assumed if it worked out for you