1. Parse a student score report with an explicit schema
Data analystBackground
A data analyst receives a padded text report containing student IDs, names, and scores.
Problem
The fields have documented character ranges, but the report must be converted into structured rows while ignoring padding spaces.
How to use
Paste the report, select Schema, mark the first row as a header, keep character positions, and enable Trim field values.
[{"name":"id","start":0,"end":5},{"name":"name","start":5,"end":15},{"name":"score","start":15,"end":20}]Outcome
The parser resolves the supplied schema, returns trimmed rows for the records, and reports zero anomalies for the correctly aligned input.