Developer & Data
Sort Text Naturally or by Numeric Value
The right order depends on what the lines represent. Item2 usually belongs before Item10 in a human list. In a strict character…
Category: Developer & Data
Developer & Data
Remove Repeated Lines With the Right Matching Rule
A contact list copied from several messages often repeats the same entry. The difficulty is deciding whether an entry with different capitalisation…
Developer & Data
Compare Two Text Versions Line by Line
A changed sentence can be easy to miss in a copied notice or configuration file. A line comparison shows which lines were…
Developer & Data
Read CSV Statistics Without Guessing the Data
A column of amounts can look tidy and still contain an empty cell or a text label. Statistics only make sense once…
Developer & Data
Append CSV Files With Matching Headers
Monthly exports are tempting to paste together. That works only when their columns mean the same thing and appear in the same…
Developer & Data
Choose and Reorder Columns in a CSV Export
An export can contain more information than the next task needs. A dispatch sheet might need name and city while leaving out…
Developer & Data
Clean Duplicate CSV Records Without Losing Cells
A repeated import can add the same rows twice. Cleaning those duplicates is different from deleting every row that shares a customer…
Developer & Data
Convert CSV to JSON While Keeping Leading Zeros
A code that looks numeric is often an identifier. A postal reference, product code or student number may need its leading zeros.…
Developer & Data
Turn JSON Records Into a Usable CSV File
An API may return records as JSON while an accounts team needs a spreadsheet. The conversion is straightforward when the document is…
Developer & Data
Compare JSON Changes by Structure and Path
Two configuration files can look different while describing the same object. Indentation and object key order often explain the visual change. A…