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



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.