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

Options

JSON to be cleaned

Choose the column containing the json to be cleaned

Characters to remove

Specify any known problem characters in the property names that are causing issues. This should be specified as a regex "character set" which identifies the set of characters to be removed, enclosed in [ ].%%00010%%00010e.g.%%00010%%00010To specify removal of just commas and single quotes, use%%00010%%00010[',]%%00010%%00010To specify removal of all non-alphanumerics, you can use the ^ regex character for "not"%%00010[^A-Za-z0-9]%%00010%%00010%%00010For help on syntax, search web for: "regex character sets and ranges"%%00010e.g. https://www.regular-expressions.info/charclass.html%%00010

Nodes

• Column Filter5 ×
• String Manipulation5 ×
• Column Rename3 ×
• Rule Engine2 ×
• Catch Errors (Data Ports)1 ×
• Cell Splitter1 ×
• Column Combiner1 ×
• Column Resorter1 ×
• Column Selection Configuration1 ×
• Component Input1 ×
• Component Output1 ×
• Duplicate Row Filter1 ×
• GroupBy1 ×
• JSON Path1 ×
• Missing Value1 ×
• Regex Split1 ×
• Row Filter1 ×
• RowID1 ×
• String Configuration1 ×
• String to JSON1 ×
• Try (Data Ports)1 ×
• Ungroup1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME JSON-Processing
• FeatureKNIME Quick Forms

Links

• No links available