topic Re: Remove @company.com characters from string field in ArcGIS Survey123 Questions

Remove @company.com characters from string field

katshier — Fri, 13 Oct 2017 03:21:46 GMT

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!

Re: Remove @company.com characters from string field

JamesTedrick — Fri, 13 Oct 2017 17:26:55 GMT

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)

Re: Remove @company.com characters from string field

katshier — Mon, 16 Oct 2017 00:30:45 GMT

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

Re: Remove @company.com characters from string field

DanielMcIlroy — Tue, 15 May 2018 05:09:08 GMT

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

Re: Remove @company.com characters from string field

JamesTedrick — Tue, 15 May 2018 16:38:56 GMT

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.

Re: Remove @company.com characters from string field

Anonymous User — Thu, 18 Oct 2018 03:14:12 GMT

Could you please post an example of this?

Re: Remove @company.com characters from string field

RobertAnderson3 — Wed, 17 Mar 2021 14:33:48 GMT

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?