CSV encoding or delimiter trouble? Read the import symptoms
Garbled letters and collapsed columns point to different parts of an import. Inspect encoding evidence and delimiter structure before changing the whole file.
About 3 min read
Explanations, comparisons and troubleshooting for everyday digital tasks. Learn how formats work, choose an approach and check your results.
Garbled letters and collapsed columns point to different parts of an import. Inspect encoding evidence and delimiter structure before changing the whole file.
About 3 min read
JSON syntax can hold a large numeric literal that a particular parser cannot represent exactly. Keep identifier semantics and parser limits in view.
About 3 min read
Successful parsing confirms a JSON structure, not the meaning of its values. Separate syntax, schema and application rules when reviewing an import.
About 3 min read
Line-by-line comparisons can make a sorted export look completely changed. Match records by a stable key when your question concerns their values.
About 3 min read
Repeated keys can create multiple matching combinations. Check the intended relationship before treating a joined table as a safe basis for totals.
About 3 min read
Two rows can share a name without representing the same record. Define identity and a survivor rule before removing duplicates from a dataset.
About 3 min read
Decide whether a column represents a quantity or an identity before importing it. Arithmetic and numeric formatting can change codes that only happen to contain digits.
About 3 min read
Clear filenames cannot replace version control, but they can stop a reviewer from choosing the wrong attachment. Use status and version deliberately.
About 3 min read