1 of 1 people found this helpful
Here's what I've got : LEN([Animal]) - LEN(REPLACE([Animal] , "[" , "" ))
Basically, it counts the number of characters in the [Animal] field, then subtracts the amount of characters in the [Animal] field but this times without " [ " in it - which gives you what you need.
Hope this is helpful,
Please check one of best Article on String Calculations by Jeff Dummy. Its has more are less 40+ formulas and find the best one which suites for your req.
Great!! Thank u. Liam