https://community.esri.com/t5/arcgis-survey123-questions/invalid-syntax-on-calculation-string-field/m-p/1307418#M50585 <P>Hi all,</P><P>Really baffled as to why this does not seem to be working for me. Attempting to create a field to automatically clip a tag read in by an RFID reader to a previous field and the "calculation - string" tab seems to not be functioning as I'm interpreting the documentation.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RachaelYoumans1_0-1689104586486.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/75206iBE6FF82D9619B003/image-size/medium?v=v2&amp;px=400" role="button" title="RachaelYoumans1_0-1689104586486.png" alt="RachaelYoumans1_0-1689104586486.png" /></span></P><P>The PIT tag number field usually will read something in like this:</P><P>07-11-2023 12:29:05 01 TAG 3E7.2794D7D37</P><P>And I am attempting to extract "3E7.2794D7D37". I would expect to do it by running the following function:</P><P>subtr(${question_7}, 27, 40)</P><P>However, any time I enter the ${}&nbsp; characters, it tells me that it is invalid syntax and won't allow me to build the function. All tutorial videos I seem to see about this are through excel and I would sure appreciate any help I can get on this one. Thanks!</P><P>&nbsp;</P> Tue, 11 Jul 2023 19:49:05 GMT RachaelYoumans1 2023-07-11T19:49:05Z https://community.esri.com/t5/arcgis-survey123-questions/invalid-syntax-on-calculation-string-field/m-p/1307418#M50585 <P>Hi all,</P><P>Really baffled as to why this does not seem to be working for me. Attempting to create a field to automatically clip a tag read in by an RFID reader to a previous field and the "calculation - string" tab seems to not be functioning as I'm interpreting the documentation.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RachaelYoumans1_0-1689104586486.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/75206iBE6FF82D9619B003/image-size/medium?v=v2&amp;px=400" role="button" title="RachaelYoumans1_0-1689104586486.png" alt="RachaelYoumans1_0-1689104586486.png" /></span></P><P>The PIT tag number field usually will read something in like this:</P><P>07-11-2023 12:29:05 01 TAG 3E7.2794D7D37</P><P>And I am attempting to extract "3E7.2794D7D37". I would expect to do it by running the following function:</P><P>subtr(${question_7}, 27, 40)</P><P>However, any time I enter the ${}&nbsp; characters, it tells me that it is invalid syntax and won't allow me to build the function. All tutorial videos I seem to see about this are through excel and I would sure appreciate any help I can get on this one. Thanks!</P><P>&nbsp;</P> Tue, 11 Jul 2023 19:49:05 GMT https://community.esri.com/t5/arcgis-survey123-questions/invalid-syntax-on-calculation-string-field/m-p/1307418#M50585 RachaelYoumans1 2023-07-11T19:49:05Z https://community.esri.com/t5/arcgis-survey123-questions/invalid-syntax-on-calculation-string-field/m-p/1307437#M50586 <P>You could try subtr(${question_7}, '27', '40')<BR /><BR />Substring only accepts string(s) as input.</P> Tue, 11 Jul 2023 20:53:15 GMT https://community.esri.com/t5/arcgis-survey123-questions/invalid-syntax-on-calculation-string-field/m-p/1307437#M50586 Raul 2023-07-11T20:53:15Z