CKcarl kevinincommenttok.hashnode.dev·2d ago · 8 min readWhy an Empty Result Is Not a Zero: Track Availability in CSV ReportsBy tokviewer.app editorial team · September 17, 2026 An empty cell tells you that a number is absent. It does not tell you whether the number was zero, whether the source omitted it, or whether the re00
XXianginfilework-notes.hashnode.dev·3d ago · 3 min readBuilding a CSV checker that leaves the decisions visibleA CSV checker can flag a suspicious value without knowing what that value should become. That distinction shaped CSV Import Preflight v0.1.0: inspect selected ID and amount columns, explain a limited 00
CKcarl kevinincommenttok.hashnode.dev·3d ago · 6 min readValidate Identifier Columns Before Trusting a CSV ExportDisclosure: Prepared with AI assistance for CommentTok, whose editorial team is affiliated with TokViewer. All sample records and identifiers are fictional. Before using an identifier column for join00
DLDonghao Liindonghao-tools.hashnode.dev·Sep 10 · 4 min readWhy deduplicating product CSVs by SKU can lose real dataA product file contains two rows with the same SKU. Removing one seems reasonable until you notice that the prices differ. Keeping the first row silently chooses one price; keeping the last silently c00
XXianginfilework-notes.hashnode.dev·Sep 8 · 4 min readOne comma. Two different numbers.A file can look clean and still carry the wrong value. The text 1,234 can mean one point two three four when the comma is a decimal symbol, or one thousand two hundred thirty-four when it groups thous00
PPetrichorinmeteosource.hashnode.dev·Sep 7 · 3 min readHistorical Weather Data in Google SheetsWeather is one of the cheapest explanatory variables you can add to a dataset. Footfall, delivery times, energy consumption, crop yields, ice cream sales. A lot of the variance you're staring at is ju00
VVisitMargininvisitmargin.hashnode.dev·Sep 6 · 4 min readCSV cleanup without silent data loss: a 16-row worked exampleA CSV can look tidier after cleanup and still be less trustworthy. Turning an identifier into a number can erase leading zeros. Picking the newest of two conflicting records can discard a fact the own00
Bbinnen48inbinnen48-slip.hashnode.dev·Sep 2 · 3 min readClose empty Solana token accounts and reclaim rent (no seed, public RPC)Every SPL token account on Solana is a rent-exempt account. When you first receive a token, an Associated Token Account (ATA) is created for that mint and funded with the rent-exempt minimum. The acco00
DMDavid Mithenindavidmithen.hashnode.dev·Jul 25 · 8 min readHow to Preserve All Contact Information During VCF to CSV ConversionIntroduction VCF(vCard) files are one of the most popular formats to store contact information. They are used extensively by Android phones, iPhones, Microsoft Outlook, Apple Contacts, Gmail and many 00
SASibtain Aliinallroundexperts.hashnode.dev·Jul 25 · 2 min readJSON vs CSV vs YAML: Which Format Should You Use?Stop Picking the Wrong Data Format Last week, a colleague spent 2 hours debugging a config file. Root cause? They chose YAML when JSON would've been clearer. Format choice matters. Here's how to pick 00
