Data Tools

Extensions for working with structured data like JSON and regular expressions.

JSON Tools

Version 2.0.1 | 15 commands

Powerful tools for manipulating JSON data. Supports smart JSON extraction with dot notation.

Conversion

• ::csv_to_json (replaceAll) — Convert CSV data to a JSON array using the first row as keys. Example: ::csv_to_json
• ::json_format (replaceAll) — Reformat JSON (pretty, compact, or minified). Example: ::json_format or ::json_format(pretty)

Sorting & filtering

• ::json_sort (replaceAll) — Sort array of objects by a key value. Example: ::json_sort(name) or ::json_sort(age, true) for reverse
• ::json_sort_array (replaceAll) — Sort primitive arrays (strings/numbers). Example: ::json_sort_array or ::json_sort_array(true) for reverse
• ::json_filter (replaceAll) — Keep only items matching a condition. Example: ::json_filter(status, =, active)
• ::json_filter_out (replaceAll) — Remove items matching a condition. Example: ::json_filter_out(status, =, inactive)

Key manipulation

• ::json_add_key (replaceAll) — Add a key-value pair to all objects in array. Example: ::json_add_key(status, active)
• ::json_remove_key (replaceAll) — Remove a key from all objects in array. Example: ::json_remove_key(temp_field)
• ::json_set_key (replaceAll) — Set a key to a specific value in all objects. Example: ::json_set_key(version, 2.0)
• ::json_append_key (replaceAll) — Append value to the end of existing key values. Example: ::json_append_key(name, _suffix)
• ::json_prepend_key (replaceAll) — Prepend value to the beginning of existing key values. Example: ::json_prepend_key(name, prefix_)

Deduplication

• ::json_get_dupes (insert) — Find duplicate objects by key or duplicate primitives. Example: ::json_get_dupes or ::json_get_dupes(email)
• ::json_dedupe (replaceAll) — Remove exact duplicate objects from array. Example: ::json_dedupe

Path access (dot notation)

• ::json_get (insert) — Get value at dot notation path. Example: ::json_get(user.profile.name)
• ::json_set (replaceAll) — Set value at dot notation path. Example: ::json_set(user.status, online)

Regex

Version 1.0.1

Use regular expressions to find, remove, or extract text patterns.

• ::regex_remove (replaceAll) — Remove all text matching a regex pattern. Example: ::regex_remove(\d+) removes all numbers
• ::regex_keep (replaceAll) — Keep only text matching a regex pattern. Example: ::regex_keep([A-Z]+) keeps only uppercase words
• ::regex_insert (insert) — Extract all matches and insert with delimiter. Example: ::regex_insert(\w+@\w+\.\w+, ,) extracts emails