Re:Missing Covid-19 test data was caused by the ill-thought-...
by jugg1es on Tuesday October 06, 2020 @10:06AM
(#24697751)
These aren't fixed-width fields with a known length. The length of the field is unique to the person sending the file and they don't tell us how long it's supposed to be.
[ Parent
| on HN ]
Re:Missing Covid-19 test data was caused by the ill-thought-...
by ivanhoe on Friday October 09, 2020 @04:07PM
(#24733884)
The parent post says: "Excel interprets a number and then formats it as a number, but in healthcare, 10 digit numbers are really strings." - so I was under impression that the length for that particular column is fixed - probably just misunderstood the sentence.
I wonder how human operators figure out if the value is correct, or the Excel messed it up, or the input was invalid in the first place? If it's even possible to do it reliably then probably there is some set of patterns and methods that possibly could be turned into an algorithm... just thinking out loud here, but seems as an interesting problem to tackle...