If there might be a trailing ‘;’ on your geotrace/geoshape - depending on whether you used Enketo vs Collect to acquire it… - then you can workaround it with a correction calculation:
if(ends-with(${mygeotrace}, ';'), substring(${mygeotrace},0,string-length(${mygeotrace})), ${mygeotrace})
workaround.xlsx (6.0 KB)
(if there’s no trailing ‘;’ then nothing changes)
BTW the root of the problem has already been fixed upstream in ODK Collect: See Remove trailing semicolon from geotrace and geoshape serialized value · Issue #4451 · getodk/collect · GitHub. Once this shows up in KoboCollect no such workaround should be necessary anymore.
