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.
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!
You could try subtr(${question_7}, '27', '40')
Substring only accepts string(s) as input.