nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Remove @company.com characters from string field

katshier

My form is capturing the username by default which is the full email address. I would like to remove the @company.com so that I'm just left with firstname.lastname in a field called 'User'.

I have looked at using an input mask, regex and a calc along the lines of substr(${username},-21) but haven't quite cracked it. I would imagine this would be quite a common requirement?

The email address would always be in the same format.

Any suggestions welcome!

Find more posts tagged with

Accepted answers

JamesTedrick

Hi Katherine,

It sounds like your organization uses enterprise logins- technically, the `@companyname` is part of the username as ArcGIS receives it from your login system.

The substr() function can be used to do this, but it requires the start and end points for the text you want to extract. The start point is 0 (the beginning); the end point can be calculated by subtracting the length of the `@companyname` part from the total length of username. In your case, it looks like that part is 21 characters long; you would have

substr(${username}, 0, string-length(${username})-21)

All comments

JamesTedrick

Hi Katherine,

It sounds like your organization uses enterprise logins- technically, the `@companyname` is part of the username as ArcGIS receives it from your login system.

substr(${username}, 0, string-length(${username})-21)

katshier

That's great, thanks James. That's exactly what I wanted.

DanielMcIlroy

Hi James, I have a related problem (and it is similar to one that I've had previously https://community.esri.com/thread/204180-find-and-replace-character )

So I need my responses to fit some very strict business rules regarding usernames, I was able to trim off the @companyname, but i need to replace the "." symbol between firstname.lastname, as the database strictly requires a firstname[space]lastname format.

I know that we previously solved a find and replace problem with some fancy footwork around changing decimals to integers, and creating a concatenated string, but this i think is a straight up find and replace problem i think. I have been trying to figure out of regex is the way to go, but put simply, my regex is atrocious!!

Hope you can help

Cheers

Dan

JamesTedrick

Hi Dan,

Doing a replacement in the middle of the string is a bit harder. There is a capability in beta that can address this though - Welcome to our Feedback Community is the link to that documentation.

Anonymous User

Could you please post an example of this?

RobertAnderson3

Hi James,

The link you posted for this in the beta forum no longer works, is there a post now that shows this capability now that it has likely gone live?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.