really? Why are you so sure about that?

K(eep)
I(t)
S(imple)
S(illy)
Get your data in, as it is, exactly as it appears from your file

*Then* do whatever validation/processing you need to do on it... don't make the problem harder than it needs to be...