Knute Snortum wrote:Would you like to post your solution back here, or tell us what you did? There may be other people with similar problems that would want to know.
Junilu Lacar wrote:Are those classes you wrote or did someone else write them?
Junilu Lacar wrote:For a Column, isn't its equivalent int stored in the x field? Similarly for Row, I would think it's the y field. Do those fields have getters?
Carey Brown wrote:Most people hate this but I'm going to offer it up anyway because it works. Regular expressions and other lexars generate state machines behind the scenes, this one is just unrolled.
Piet Souris wrote:In my reply I suggested to use a dedicated class to collect all the fields of a block, and I suggested to converse some strings of a block into more useful types. For instance, if, after splitting a block, we have the fields f1 = "Dec 17" and f2 = "2019 9:00:00 PM", then we can put these into a useful LocalDateTime, with a suitable DateTimeFormatter. I did not tell how that could be done, but here is a way
With this, we can get:
Knute Snortum wrote:I'm not sure that's going to work properly. There is an element
"LASTNAME, FIRSTNAME"
that should be all one element and not be split by the comma. I would look into using a CSV library like
http://commons.apache.org/proper/commons-csv/