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; } } }

"Search, or Find function for Calculation

MarkBennett

Dear all,

I need to calculate for a field based on the position of a substring in another question. It should be similar to the SEARCH("search string", "String Value", start position) in Excel or Find function.

I need to do a "auto-fill" for a field using a substring in a provirus question. I need to find the numbers of starting and ending position for the "substr" function.

Thanks!

Ming

Find more posts tagged with

Accepted answers

All comments

JamesTedrick

Hi Ming,

We are working on this tentatively for our March release.

MarkBennett

Is there any update on this function in the new release?

Thanks!

MarkBennett

Thanks for let me know!

Ming

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

JamesTedrick

Hi Miing,

Unfortunately, there is not a function to search of a string and return it's position in the XLSform specification. We are looking into ways to support additional functions beyond the XLSForm spec - this request is similar to https://community.esri.com/ideas/14267 (the ability to parse is the same need for variable length substr)

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.