> > > > 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?
Pretty sure it's a text file, each new field for information gets interpreted as being on a new line by NOTEPAD, so there must be newline chars at the end of each line. But sure, I'll upload a file tomorrow.
- Stiletto
|