> > 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
|