Select to view content in your preferred language

Invalid syntax on Calculation String field survey123

296
1
07-11-2023 12:49 PM
RachaelYoumans1
New Contributor

Hi all,

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. 

RachaelYoumans1_0-1689104586486.png

The PIT tag number field usually will read something in like this:

07-11-2023 12:29:05 01 TAG 3E7.2794D7D37

And I am attempting to extract "3E7.2794D7D37". I would expect to do it by running the following function:

subtr(${question_7}, 27, 40)

However, any time I enter the ${}  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!

 

0 Kudos
1 Reply
Raul
by
New Contributor III

You could try subtr(${question_7}, '27', '40')

Substring only accepts string(s) as input.

0 Kudos