AnsweredAssumed Answered

Survey123 x and y locations

Question asked by rod.lockie_Beca on Aug 10, 2016
Latest reply on Aug 11, 2016 by JTedrick-esristaff

Hi,

 

I am trying to get two calculations sorted so that i can separate the x and y coordinates in to two fields.

 

I have tried the substr method that so i can have one start at the x and then one start at the y. Only problem with this method is that the y starting point fluctuates. which means it can be right sometimes and completely wrong the other times.

 

My question is does the Survey123 xlsform have a calculation similarly to the FIND in excel where you can find the location of a character in a string.

 

e.g FIND("-", ${location}) would give the position of - in the location field.

 

I can then use this inside a substr calculation to specify a starting point.

 

Thanks in advance would love to know if this is possible yet.

Outcomes