Delim Converter

Convert lists between comma, pipe, tab, and custom delimiters with advanced options.

Input 0 items

Output 0 items

⚙️ Settings

Tidy Up Remove newlines

Attack clones Remove duplicates

Explode

Quotes

None Double " " Single ' '

Delimiter

Text Reverser — Reverse a String, Words, or Lines Online

The Text Reverser flips text three different ways: reversing the characters within each line, reversing the order of words, or reversing the order of lines. It's built for developers checking palindrome logic, writers experimenting with text effects, or anyone who needs to reverse a string online quickly without writing code. Paste your text, pick a mode, and get the reversed result instantly.

⚡ Key Takeaways

Three distinct modes: reverse characters, reverse word order, or reverse line order.
Each mode is independent — combining effects means applying them one after another.
Reverse Lines never touches the text inside each line, only their order.
Useful for palindrome checks, log reordering, and simple text puzzles.

What, Who, When & Why

What it's for	Reverses text three ways: flipping characters within a line, reversing word order, or reversing line order.
Who it's for	Developers checking palindrome or string-reversal logic, and anyone needing a quick text-reversal effect.
When to use it	When testing code that reverses strings, verifying a palindrome, or wanting to reorder a list from newest-first to oldest-first (or vice versa).
Why it's needed	Reversing text by hand is slow and error-prone for anything beyond a few characters, and each of the three reversal types requires different manual logic.
Best way to use it	Pick the specific mode that matches what you actually need — character, word, or line reversal — since they produce very different results and aren't interchangeable.

How to Use the Text Reverser

Paste or type your text into the Input box.
Click Reverse String to flip the characters within each line.
Or click Reverse Words to reverse the order of words within each line.
Or click Reverse Lines to reverse the order of the lines themselves.
Copy the result from the Output box.

Example

Starting with the line hello world:

Mode	Result
Reverse String	`dlrow olleh`
Reverse Words	`world hello`

With multiple lines like first line and second line, Reverse Lines swaps their order so second line appears first, while leaving the text within each line completely untouched. This makes it easy to view a chronological list in reverse order without altering any of the actual content.

Key Features

Reverse String — flips the character order within each line individually.
Reverse Words — reverses word order within each line, keeping the words themselves intact.
Reverse Lines — reverses the order of lines in a multi-line block, without touching each line's content.
Handles multi-line text correctly in every mode, without merging content across lines.

Practical Use Cases

Checking palindromes: reverse a string to visually confirm it reads the same backward.
Text puzzles or games: generate reversed text for word games or simple obfuscation.
Reordering a list: reverse the line order of a chronological list to view it newest-first or oldest-first.
Debugging string logic: quickly verify what a reversed string or word order should look like when testing code that manipulates text.
Flipping log output: reverse the line order of a log file to read the most recent entries first.

Tips for Best Results

If you need to reverse everything at once — characters, words, and line order — apply each mode one after another, copying the intermediate result back into the input each time.
Use Reverse Lines on exported log or chat data to quickly flip chronological order without manually scrolling to the bottom.
Reverse String is a fast way to manually verify palindrome logic while debugging code, without writing a temporary test script.

Related Terminology

A palindrome is a word or phrase that reads the same forward and backward (like "level" or "racecar"). Character reversal flips individual letters, while word reversal keeps each word spelled correctly but changes their order — these are distinct operations with different use cases, and neither one automatically implies the other.

Important Considerations

Each mode operates independently — reversing characters won't also reverse word or line order, and vice versa. If you need to reverse everything at once, apply the modes one after another and copy the intermediate result back into the input. Multi-line input is handled per-line for the String and Words modes, meaning line breaks themselves are preserved in their original position unless you specifically use Reverse Lines.

Related Tools

Once reversed, you might want to adjust capitalization with the Case Converter, or sort the result with the Alphabetical Sorter. To count characters in your reversed text, use Text Statistics.

Frequently Asked Questions

How do I reverse a string online?

Paste your text into the Input box and click Reverse String — each line's characters are flipped instantly.

What's the difference between Reverse String and Reverse Words?

Reverse String flips the individual characters within a line (turning "hello" into "olleh"), while Reverse Words keeps each word spelled normally but reverses their order (turning "hello world" into "world hello").

Does Reverse Lines change the text within each line?

No, Reverse Lines only changes the order lines appear in — the content of each individual line stays exactly the same.

Can I combine all three reverse modes at once?

Not in a single click, but you can apply them one after another — reverse the string, copy the result back into the input, then reverse the words or lines next.

Find & Replace

Bulk replace multiple strings at once — add as many find/replace conditions as you need.

Input

Output

Find & Replace Conditions

Prefix / Suffix Stamper

Add custom prefix and suffix to every line.

Input

Output

Whitespace Trimmer

Strip, collapse, or remove all whitespace. "Clean All" does both trim and collapse in one click.

Input

Output

Column Extractor

Extract specific columns from CSV/TSV data.

Input (CSV/TSV)

Output

Split by Chunk

Split a long string into fixed-width chunks.

Input

Output

Alphabetical Sorter

Sort lines A→Z, Z→A, or by line length.

Input

Output

Escape / Unescape

Escape to HTML entities or JSON strings, or unescape back.

Input

Output

Line Number Stamper

Add incremental line numbers (001, 002, 003...) to each row.

Input

Output

SQL Value Generator

Wrap each line in quotes and join → ('a','b','c')

Input

Output

Date Range Generator

Generate a list of dates between two dates with custom intervals.

Start Date

End Date

Interval

Format

Output

Epoch Converter

Convert Unix timestamps to human-readable dates and vice versa.

Unix Timestamp

Human Date

Result

SQL Formatter

Beautify or minify SQL queries with proper indentation.

Input SQL

Output

CASE Statement Builder

Build SQL CASE WHEN statements one condition at a time — no special syntax to remember.

Column / Expression

Conditions

Else (default value)

Generated SQL

Query Sanitizer

Strip comments, SET statements, and trailing semicolons from SQL.

Input SQL

Output

📌 Sticky Notes

Organize your thoughts, tasks, and ideas with drag-and-drop sticky notes.

📌

Click "+ Add Note" to create your first sticky note.

Text Comparator

Compare two texts and see the differences highlighted.

Text A

Text B

Ignore case Ignore whitespace

Differences

Click "Compare" to see differences highlighted.

Ready to compare

Text Statistics

Get detailed statistics about your text: words, characters, paragraphs, sentences, and more.

Input Text

📝 Words

🔤 Characters

📏 Characters (no spaces)

📄 Sentences

📑 Paragraphs

📃 Lines

📊 Avg word length

📊 Avg sentence length

Detailed Results

SQL Query Templates

Ready-to-use boilerplate for common query patterns — CTEs, joins, date rollups, window functions, and stored procedures. Click Copy and adapt the table/column names.

CTE

Basic CTE (Common Table Expression)

Break a query into a readable, reusable named block.

WITH recent_orders AS (
    SELECT
        customer_id,
        order_id,
        order_date,
        total_amount
    FROM orders
    WHERE order_date >= DATEADD(day, -30, GETDATE())
)
SELECT
    customer_id,
    COUNT(order_id)   AS order_count,
    SUM(total_amount) AS total_spent
FROM recent_orders
GROUP BY customer_id
ORDER BY total_spent DESC;

Recursive CTE (hierarchy / org chart)

Walk a parent-child tree, e.g. an employee/manager hierarchy.

WITH RECURSIVE employee_hierarchy AS (
    -- Anchor: top-level rows (no manager)
    SELECT
        employee_id,
        manager_id,
        employee_name,
        1 AS level
    FROM employees
    WHERE manager_id IS NULL

    UNION ALL

    -- Recursive: join children to their parent's result
    SELECT
        e.employee_id,
        e.manager_id,
        e.employee_name,
        eh.level + 1
    FROM employees e
    INNER JOIN employee_hierarchy eh
        ON e.manager_id = eh.employee_id
)
SELECT *
FROM employee_hierarchy
ORDER BY level, employee_name;
-- Note: SQL Server / Oracle: drop the RECURSIVE keyword (just WITH employee_hierarchy AS (...))

Joins

INNER / LEFT JOIN across multiple tables

Combine orders with customers and line items in one query.

SELECT
    o.order_id,
    c.customer_name,
    o.order_date,
    p.product_name,
    oi.quantity
FROM orders o
INNER JOIN customers c
    ON o.customer_id = c.customer_id
LEFT JOIN order_items oi
    ON o.order_id = oi.order_id
LEFT JOIN products p
    ON oi.product_id = p.product_id
WHERE o.order_date >= '2026-01-01'
ORDER BY o.order_date DESC;

GROUP BY / Dates

Monthly rollup with GROUP BY on a date

Aggregate a date column by month (swap the truncation line for your engine).

SELECT
    DATE_TRUNC('month', order_date) AS order_month,     -- PostgreSQL
    -- FORMAT(order_date, 'yyyy-MM')  AS order_month,    -- SQL Server
    -- DATE_FORMAT(order_date, '%Y-%m') AS order_month,  -- MySQL
    COUNT(*)          AS order_count,
    SUM(total_amount) AS revenue
FROM orders
GROUP BY DATE_TRUNC('month', order_date)
ORDER BY order_month;

Window Functions

ROW_NUMBER + running total

Rank each customer's orders and compute a running total.

SELECT
    customer_id,
    order_id,
    order_date,
    total_amount,
    ROW_NUMBER() OVER (
        PARTITION BY customer_id
        ORDER BY order_date DESC
    ) AS order_rank,
    SUM(total_amount) OVER (
        PARTITION BY customer_id
        ORDER BY order_date
        ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
    ) AS running_total
FROM orders;

Stored Procedures

Parameterized stored procedure

A basic proc with optional date-range filters (T-SQL syntax).

CREATE PROCEDURE GetCustomerOrders
    @CustomerId INT,
    @StartDate  DATE = NULL,
    @EndDate    DATE = NULL
AS
BEGIN
    SET NOCOUNT ON;

    SELECT
        order_id,
        order_date,
        total_amount
    FROM orders
    WHERE customer_id = @CustomerId
        AND (@StartDate IS NULL OR order_date >= @StartDate)
        AND (@EndDate   IS NULL OR order_date <= @EndDate)
    ORDER BY order_date DESC;
END;
-- Call it: EXEC GetCustomerOrders @CustomerId = 101, @StartDate = '2026-01-01';

Upsert / Merge

MERGE (upsert) from a staging table

Insert new rows and update matching ones in a single statement.

MERGE INTO customers AS target
USING staging_customers AS source
    ON target.customer_id = source.customer_id
WHEN MATCHED THEN
    UPDATE SET
        target.customer_name = source.customer_name,
        target.email         = source.email,
        target.updated_at    = GETDATE()
WHEN NOT MATCHED THEN
    INSERT (customer_id, customer_name, email, created_at)
    VALUES (source.customer_id, source.customer_name, source.email, GETDATE());

🎨 Color Picker & Converter

Pick a color (or type a value) and get HEX, RGB, HSL, HSV, and CMYK instantly — copy any format with one click.

HEX

#FACC15

RGB

rgb(250, 204, 21)

RGB Percent

rgb(98%, 80%, 8%)

HSL

hsl(46, 96%, 53%)

HSV / HSB

hsv(46, 92%, 98%)

CMYK

cmyk(0%, 18%, 92%, 2%)

CSV ⇄ JSON Converter

Paste CSV or JSON and convert between them. Handles quoted fields, embedded commas, and nested-safe escaping.

Input

Output

SQL Query Explainer

Paste a SQL query and get a plain-English, structured breakdown of what it does. Pattern-based — works fully offline, no AI involved.

SQL Query

Plain-English Breakdown

Unit Converter

Convert data sizes and time durations. Pick a category, enter a value, and see it converted to every other unit.

Tools for analysts, developers & QA engineers

33 free, browser-based utilities — text and list tools, SQL helpers, converters, and small productivity apps. Everything runs locally; nothing you type or paste is ever uploaded.

📊

For Analysts

Clean lists, build SQL fragments, and reshape data without opening a spreadsheet.

💻

For Developers

Format SQL, convert data formats, and handle everyday text and encoding tasks.

🧪

For QA Engineers

Generate test data, compare text output, and sanitize queries before sharing them.

⚙️ Settings

Text Reverser — Reverse a String, Words, or Lines Online

⚡ Key Takeaways

What, Who, When & Why

How to Use the Text Reverser

Example

Key Features

Practical Use Cases

Tips for Best Results

Related Terminology

Important Considerations

Related Tools

Frequently Asked Questions

How do I reverse a string online?

What's the difference between Reverse String and Reverse Words?

Does Reverse Lines change the text within each line?

Can I combine all three reverse modes at once?

Archived Notes

Tools for analysts, developers & QA engineers

For Analysts

For Developers

For QA Engineers

Core Tools

SQL Tools

Productivity

Analysis

Design