Within a automation I am doing an Advanced compare condition that is:
{{fieldChange.toString.left(fieldChange.fromString.indexOf(":"))}}
This gets me the start of the string up to the character before the ":". However, I want to include ":", so have tried is:
{{fieldChange.toString.left(fieldChange.fromString.indexOf(":")+1)}}
But this gives and error. How do I add 1 to the indexOf?