https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79535#M31406 I meant could it be possible that x/2 is not producing a whole number, eg 3/2 Fri, 16 Mar 2018 18:22:00 GMT John__Carter 2018-03-16T18:22:00Z https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79532#M31403 Hi, We seem to be having a super weird error with a very simple function using mid / len / trim. The function is validated (by clicking on validate) and 'evaluate expression' gives out the correct result in process/object studio, every time (on multiple computers, with different settings etc.) However, when run outside of process/object studio, it always produces an error - 'failed to evaluate expression (...) - unexpected ) in parameters' The function is super simple (attached a pic as well) Mid(Trim([dataItem1]), "1", (Len(Trim([dataItem1]))/2)) Any ideas?         Wed, 14 Mar 2018 11:48:00 GMT https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79532#M31403 TomaszKucharczy 2018-03-14T11:48:00Z https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79533#M31404 Could the divide by 2 be producing a non-integer value? Wed, 14 Mar 2018 16:40:00 GMT https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79533#M31404 John__Carter 2018-03-14T16:40:00Z https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79534#M31405 No, since the length of the string is always bigger than 1 (and can't be empty).  I couldn't find any solution and attempted something stupid - I moved this from write stage to calculation stage, passed the value to a data item and used said data item in the write stage instead. That fixed the issue, so it seems to be a bug in BP. Fri, 16 Mar 2018 14:34:00 GMT https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79534#M31405 TomaszKucharczy 2018-03-16T14:34:00Z https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79535#M31406 I meant could it be possible that x/2 is not producing a whole number, eg 3/2 Fri, 16 Mar 2018 18:22:00 GMT https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79535#M31406 John__Carter 2018-03-16T18:22:00Z https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79536#M31407 Replace ""1"" with 1 and try. Wed, 25 Apr 2018 13:27:00 GMT https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79536#M31407 VishalPrajapati 2018-04-25T13:27:00Z https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79537#M31408 Had the same issue with expression ""01-Jan-""&FormatDate(AddMonths(Today(); 12); ""yyyy"") in write stage. error message : Syntax error. The token '(' is invalid. Please check the case of your operators (eg 'or' versus 'OR') and check that your functions use brackets after the function name eg Now(), eg Len(""abc""). Validation shows its working fine, the solution with move the expression to calc stage too... so just wonder what could be the issue.   Mon, 18 Jun 2018 18:01:00 GMT https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79537#M31408 RostislavPelika 2018-06-18T18:01:00Z https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79538#M31409 Check you regional settings and ensure that number formats do not use commas for decimal, separators etc.  I saw similar behaviour and from what I could tell the inclusion of commas in value passed causes the text parser to expect a parameter. Mon, 13 Aug 2018 17:25:00 GMT https://community.blueprism.com/t5/Product-Forum/Standard-text-functions-not-working/m-p/79538#M31409 NevilleWatson 2018-08-13T17:25:00Z