JSON Property Name Cleaner

Parses the property names in JSON to remove any known problem characters.

Specify the json column, and the list of individual characters to be removed, using a regex character set (sequence of characters and character-ranges enclosed in [ ] )

Updated v1.1 - also returns a table of property names wth their replacement names.

@takbb Brian Bates 27 May 2023

Input ports

1. Type: Table
   JSON Data
   A table containing a JSON column to be parsed

Output ports

1. Type: Table
   Cleaned JSON
   The JSON with selected characters removed from the property names
2. Type: Table
   Property Key Change List
   A list of property key names and found in the source json, and their replacements in the output