Dictionary Table

First, of course we can check the type field, but then we need to determine the JSON format in use. I too am still struggling with this and how to tell the differences. There is however a pattern of prefix and suffix of the whole text field which should be able to tell us, the format in use. It is possible to expand the format with spaces, tabs and newlines to make them more readable so perhaps we need to develop regular expression based tests;

We should be able to make a custom operator that checks in the text field has the prefix/suffix for each type and return a name representing each format. Allowing our different solutions to know how to access the different format.

Here is some prior art;