MAMEWorld Forums - Programming - Re: Batch file processing...

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