Thanks for all the help.
<br/><br/>I like the idea of having the code sense the format of the data and acting accordingly.
<br/><br/>For separators, I could count the number of each kind of separators in the file and compare it to the number of lines. Say 3 or more separators per line.
<br/><br/>Then I can parse by columns and look for the dominant data type. For a column that is 60% matching a date type, I can assume it is a date column and the mismatches are headers.
<br/><br/>The amount should be numeric.
<br/><br/>The payee should be mostly letters, etc.
<br/><br/>One issue I have is knowing what to call the object that does this. It would not be a Transaction, because this is a function of many Transactions.
<br/><br/>FileLoader? FileAnalyzer?
<br/><br/>Also, at this point I should be looking for missing dates and duplicates.
<br/><br/>Duplicates are troublesome, since everytime I download the file, it starts from the beginning of the year again. I keep downloading them because I think they will only keep data for 6 months or so.
<br/><br/>Also duplicate transactions are valid. Suppose I go into a coffee shop and buy a cup of coffee, then go back the same day, same store for a refill.
<br/><br/>Your thoughts?
<br/><br/>Sincerely,
<br/><br/>Joe.
<br/><br/><br/>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://forum.world.st/conceptual-design-help-tp4892763p4892966.html">Re: conceptual design help</a><br/>
Sent from the <a href="http://forum.world.st/Squeak-Beginners-f107673.html">Squeak - Beginners mailing list archive</a> at Nabble.com.<br/>