Extensions for working with structured data like JSON and regular expressions.
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_dedupePath 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)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