Syntax for "find pattern" text function in triggered actions

[Felix]

Hello,

Does anyone know what language/syntax the "find pattern" text function in triggered actions uses?

I'm trying to extract a piece of text that lies between two characters (+ and _).

Does it use regex or something else?

Thanks!

Felix

[NailDyanC]

Hi @Felix,

I have a workaround to this but it is not by using a triggered action, this workaround is by using a formula field and some text manipulation formula. You may consider checking this:

SUBSTRING((RIGHT([@field:Leader_Text], LEN([@field:Leader_Text]) - PATINDEX('%+%', [@field:Leader_Text]))),0, CHARINDEX('_',(RIGHT([@field:Leader_Text], LEN([@field:Leader_Text]) - PATINDEX('%+%', [@field:Leader_Text])))))

Just change the fieldname to the field that you are currently using. I hope that helps.

[NailDyanC]

For more details, you may consider checking the function reference of Caspio: https://howto.caspio.com/function-reference/