JOINLINES.IO · БЛОГ

Блог.

Обновления, когда что-то выходит. Заметки о тексте, инструментах и странных краях редактирования простого текста. В основном короткие.

GUIDE 2026-05-23
How to verify an online tool doesn't upload your data

A 30-second DevTools recipe that confirms (or disproves) any browser tool's "your data never leaves your browser" claim — in Chrome, Firefox, Safari, and Brave. Plus how to spot false positives.

8 min
GUIDE 2026-05-21
What is natural sort? (file2 before file10, finally)

Why default sort puts file10 before file2, what natural sort does instead, and how to get it in Windows Explorer, macOS Finder, GNU sort, JavaScript, Python, and a one-click browser tool.

9 min
GUIDE 2026-05-19
How to chunk a large text file for LLM processing

Five ways to split text into LLM-ready chunks — the browser splitter, tiktoken, LangChain RecursiveCharacterTextSplitter, semantic chunking, or a one-off Python loop. With 2026 context-window data and the chars-vs-tokens trap.

10 min
GUIDE 2026-05-16
How to compare two CSV files (added, removed, changed rows)

Five ways to diff two CSV files by key column — pandas merge with indicator, Simon Willison's csv-diff, daff, SQL outer joins, or the browser line-compare for extracted columns.

9 min
GUIDE 2026-05-14
How to clean a messy CSV file

Six recurring CSV sins (whitespace, blanks, duplicates, casing, line endings, BOM) and the right tool for each — a browser chain, Excel Power Query, pandas, or csvkit. Multi-tool workflow walkthrough.

10 min
GUIDE 2026-05-11
How to convert a list to a JSON array

Five ways to turn a list of values into a valid JSON array — a browser chain of prefix + suffix + joiner, Excel TEXTJOIN with quote escaping, jq one-liner, or Python json.dumps. With the trailing-comma and quote-escape traps.

8 min
GUIDE 2026-05-09
How to remove blank lines from text

Five practical ways to delete blank or whitespace-only lines — Excel filter, Notepad++ regex, the awk one-liner, or an instant browser tool. With the empty-vs-blank-line trap most regex misses.

7 min
GUIDE 2026-05-06
How to dedupe a list (emails, names, strings)

Six ways to remove duplicates from a list — Excel UNIQUE, Google Sheets, Notepad++, VS Code Sort Lines, sort -u, the order-preserving awk recipe, or a browser tool. With the case-and-whitespace gotcha that creates false matches.

8 min
GUIDE 2026-05-03
How to count words in any text

Six ways to count words — Word's Word Count dialog, Excel/Sheets formulas, Notepad++, VS Code extensions, wc -w, or a browser tool that shows five stats at once.

7 min
GUIDE 2026-04-30
How to sort lines by length

Six ways to sort lines by character length — the browser tool, VS Code's Sort Lines extension, Excel SORTBY, an awk + sort pipeline, or PowerShell Sort-Object. Plus the longest-line shortcut that skips a full sort.

7 min
GUIDE 2026-04-27
How to split a large CSV file into smaller files

Five practical ways to split a large CSV — the Unix split command, PowerShell, pandas, Excel Power Query, or a browser tool. With the header-row trick most splitters skip.

9 min
GUIDE 2026-04-24
How to alphabetize a list (Excel, Word, Sheets & more)

Five practical ways to sort a list alphabetically — Word, Excel, Google Sheets, VS Code, or an instant browser tool. Covers natural sort, case-sensitivity, and dedupe.

7 min
GUIDE 2026-04-21
How to remove line breaks from text (Excel, Word & more)

Five practical ways to strip line breaks from any text — Excel, Word, Notepad++, the terminal, or an instant browser tool. Decision table at the end.

7 min
GUIDE 2026-04-18
How to count lines in a text file or string

Six ways to count lines, words, and characters — from wc on the command line to Excel COUNTA, the Word Count dialog, and an instant browser tool. With the trailing-newline gotcha that fools every basic tool.

7 min
GUIDE 2026-04-15
How to join multiple lines into one line

Five ways to glue lines together with any separator — Excel TEXTJOIN, Word Find & Replace, Notepad++ regex, the Unix paste command, or a browser tool. Includes the SQL IN() recipe.

8 min
GUIDE 2026-04-11
How to add a prefix to every line of text

Five ways to put a string at the start of every line — Excel formula, Notepad++ regex, VS Code multi-cursor, sed/awk, or an instant browser tool. Markdown bullets, email quotes, code indent, SQL prep.

7 min
GUIDE 2026-04-08
How to add a suffix or comma to every line

Five ways to put a string at the end of every line — Excel concatenation, Notepad++ regex, VS Code multi-cursor, sed/awk, or an instant browser tool. SQL terminators, CSV rows, HTML <br>, status marks.

7 min
GUIDE 2026-04-04
How to compare two lists: common, different, unique

Five ways to find what overlaps between two lists, what is only in A, only in B, or the union — Excel COUNTIF, Google Sheets, the Unix comm command, Python sets, or a browser tool.

8 min
COMPARE 2026-03-31
Online text tools vs Excel vs command line: when to use which

Three families of tools cover almost every text-manipulation job — and the right pick is rarely about which is "best". A decision tree, three worked examples, and three myths to retire.

8 min
§ — КОНФИДЕНЦИАЛЬНОСТЬ Ваш текст никогда не покидает браузер. Без загрузки, без аккаунта, без логов того, что вы вставили.
СТРАНИЦА КОНФИДЕНЦИАЛЬНОСТИ ↗