Substring of Email Id

(0) Share

Report

Posted on by skd

390

Hey Team,

I have an email id of an employee and while creating the UserId of that employee, I want the prefix of the email i.e. the part before @ in the email.

Eg: if email is Alex.Martin2@xyz.com then I want the userId = Alex.Martin2. So how can we do this, like we have split function in PowerApp, is there any function here we can use to get the above result?

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

Hi skd,

x++ has plenty of string functions, you can find them here: docs.microsoft.com/.../xpp-string-run-time-functions

You have many options to use these functions to achieve the goal.

One is here:

1) Use strFind to find the position of @ character.

2) Then use subStr to read part of the string, from beginning until the position that you found with strFind.

Was this reply helpful? Yes No
Verified answer

ergun sahin 8,826 Moderator on at

Like (1)

Report
str name = "Alex.Martin2@xyz.com"; name = subStr(name,1,strFind(name,"@",1,strLen(name))-1);

Was this reply helpful? Yes No
skd 390 on at

Like (0)

Report
Hey Nikolaos Mäenpää,

Thank you this helped me.

I had another question if in the above example I want it this way:

str email = Alex.Martin2@xyz.com; Name = Alex Martin2

How can I achieve this. I want to use the given email id to form the username. Remove the "." and add space between the first name and last name. Which methods can I use to achieve this? Pls help me.

Was this reply helpful? Yes No
skd 390 on at

Like (0)

Report

Hey Ergun Sahin,

Thank you, this helped me. Please can you help me with the username query as well?

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,795 Most Valuable Professional on at

Like (0)

Report

You already know how to get Alex.Martin2. Then use strReplace() to replace dots with spaces.

Was this reply helpful? Yes No
skd 390 on at

Like (0)

Report

Okay, Thank you.

Was this reply helpful? Yes No