> > > Okay, so on a work computer I have a file directory similar to this: > > > > {SNIPPIY-SNIP} > > > > I could probably write something like that in Java. I have similar file processing > > programs that I've written that I could just cannibalize. > > Great, thankee kindly. > > > Would this be a one-off program or something that you need to run daily? > > Basically one-off, not something production-quality. I may have need to run it again > eventually. > > > Should your output CSV have the STATE as well? or is there going to be one CSV per > > state? > > No, STATE is not important, although the complete filename with path would certainly > not go amiss since the plan is to only have one CSV. Basically the goal is to > partially automate comparing to see if CITY1 matches CITY2. If it's completely off, > then usually it will mean that the content of the file had been overwritten but the > filename remained unchanged. This however does not check for the case where NAME or > PHONE no longer match CITY2, but the only way I have to check for that case is > manually. On over 1000 files. Arrgh! > > I was however wrong about the cutoff ASCII within the file. The file content is more > like this: > > ...header... > NAME Joe Smith > CITY2 Detroit > PHONE 3015551212 > IMAGE encoded monochrome image > ...other fields... > ...footer... > > - Stiletto
Wait... are these files binary? All the tools I've written in java were text based "line at a time" processing tools. If they're binary files, it might take a bit of reworking. Do you have a sample file that I could experiment with? Are the headers fixed length?
GroovyMAME support forum on BYOAC
|