Error when the term 'version (' appears in a character string

Many thanks for your reply and your xlsx file.

I think there are two problems:

  1. using some characters in default, as reported for example here: Default with brackets gives deployment error. I only use default to illustrate the problem. I have also used calculate in your example as shown in the attached.
  2. the problem I am reporting has to do with the transformation of the string “version[(]” into a number followed by a time stamp or removing the text in the string. I attach your file modified and the error I get.


problem_version_04.xlsx (11.7 KB)

Note that my use of quotation marks it is just to avoid the problem of having brackets in the default text. Actually, the original problem was generated retrieving such string using pulldata (the text pulled had the string ‘achieving seroconversion (’. I use default text to simplify the explanation and code used in the community posts. Therefore, this problem is even more tricky because the error only shows when the pulldata is executed and not when the form is deployed.

X