"Search, or Find function for Calculation

412
11
12-08-2017 11:39 AM
Highlighted
New Contributor III

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

Tags (1)
Reply
0 Kudos
11 Replies
Highlighted
Esri Esteemed Contributor

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  (the ability to parse is the same need for variable length substr)

Highlighted
New Contributor III

Thanks for let me know!

Ming

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

Reply
0 Kudos
Highlighted
New Contributor III

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

Thanks!

Reply
0 Kudos
Highlighted
Esri Esteemed Contributor

Hi Ming,

We are working on this tentatively for our March release.

Highlighted
Occasional Contributor III

JTedrick-esristaff‌ did this make it to the 2.7 build?

Reply
0 Kudos
Highlighted
Esri Esteemed Contributor

Hi Renato,

We have not quite finalized the feature; it is, however, available for testing; documentation is in the Early Adopter Community.

Reply
0 Kudos
Highlighted
New Contributor III

Hi James,

I downloaded the 3.0 Alpha. However, I cannot find the documentation on the use of this function. Could you help me locate the usage of this function?

Thanks,

Ming

Reply
0 Kudos
Highlighted
Esri Esteemed Contributor

Hi Ming,

The appropriate document in the Early Adopter Community is Welcome to our Feedback Community .  If you have questions about the functionality, please post in the Early Adopter Community.

Reply
0 Kudos
Highlighted
New Contributor II

Hi James

I've now got a similar query - did this functionality ever make it to S123 and if so what is the function called?

Thanks,

Tom 

Reply
0 Kudos