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.
