A new service register has identifiers, fractional hours and score text that sometimes contains a status message. Inspect what each field means before choosing its type. Keep the leading zeros in ID and preserve zero hours as a recorded value.
These tasks review schema choices and text cleanup on fresh fictional records. They deliberately separate a type conversion from the decision about which rows belong in the output. A wrong type can produce a plausible preview while losing information. The hidden register changes which team has spaces, which score is malformed and how many rows arrive. Your transformations must follow the field meanings, rather than the first few visible values.