Perfect! Glad you could adapt it to the known data conditions.Plugged this in and noticed one correction the logical test needs to be >2, not >1. For the strings where there is one colon the logical test equals 2
Great formula dude!
I had to parse a massive JSON string last month so had a lot of practice with this sort of stuff. Fortunately it was in SQL which has better string functions, but same idea.
And yes, I know there are SQL JSON functions in SSMS 17 but I was running 14.