Skip to content

feat: List & Delimiter Transformer — comma, newline, JSON array, SQL IN() clause, and deduplication #97

Description

@ajithakdev

Summary

Add a versatile text list and delimiter transformer for developers, data analysts, and non-technical spreadsheet users needing to quickly reformat lists of IDs, emails, names, or values.

Motivation

Developers and technical operators daily copy lists of IDs or usernames from Slack, CSVs, or Excel and need to convert them into SQL IN ('a', 'b') clauses, comma-separated lists, JSON arrays, or space-separated CLI arguments. Current online tools either upload the list to a remote server or lack basic sorting and deduplication options.

Features

  • Delimiter Conversion:
    • Presets: Newlines (one per line), Commas (,), Comma + Space (, ), Semicolon (;), Tabs (\t), Pipes (|), Custom delimiter.
  • Quotes & Enclosures:
    • Wrap items in single quotes ('item'), double quotes ("item"), backticks (item), or custom prefixes/suffixes.
    • SQL IN Clause preset: IN ('val1', 'val2', 'val3').
    • JSON Array preset: ["val1", "val2", "val3"].
    • Python / JS Array syntax output.
  • List Operations:
    • Deduplicate items (case-sensitive or case-insensitive).
    • Sort alphabetically (A-Z, Z-A), numerically, or naturally.
    • Trim leading/trailing whitespace.
    • Remove empty lines / blank items.
    • Item counter & duplicate count metrics.

Engineering & Privacy

  • 100% Client-Side: Processes 100,000+ line lists instantly in-memory.
  • Zero Network Calls: Ideal for sensitive customer emails, user IDs, and production keys.
  • Zero Dependencies: Pure browser JavaScript.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requestgood first issueGood for newcomersnew toolA new tool addition to the toolkit

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions