topic MID Function throwing Syntax error in Product Forum

MID Function throwing Syntax error

StephanieStrydom — Thu, 09 Jun 2022 10:42:37 GMT

Hi, just installed vresion 6.10 and the MID function for text is not working.

Input
Mid("Stephanie", 1, 2)

Error:
BluePrism.AutomateProcessCore.InvalidExpressionException: Syntax error. The token '2' 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").
at AutomateUI.ctlProcessExpressionBuilder.TestExpression(String localExpr)

Re: MID Function throwing Syntax error

John__Carter — Thu, 09 Jun 2022 12:48:46 GMT

Hi Stephanie - I had this issue and found a (not very nice) workaround is to add spaces on both sides of the commas, like this:

Mid("Stephanie" , 1 , 2)

I think problem this due to langue/locale settings where the expression validator gets confused by the commas, and I have raised a bug fix with our product team. In my case I eventually realised that on the BP log in screen I had my language set to English (Europe), and when I set it back to English (United Kingdom) the problem was gone.

Re: MID Function throwing Syntax error

StephanieStrydom — Fri, 10 Jun 2022 07:54:33 GMT

Thank John, agree it must be the regional settings, all my full stops (for timeout times) changed to commas in my actions when I imported the process to the new VM. My work around was less nice, I stored the number values in number Data Items, which fixed the issue. Will see if I can change the regional settings.