RE: process a list of files

You could use a translation table at the file level--even in a logical
view. That way when those fields are read, the * and other special
characters can be translated to a benign character.

Bob Cozzi
cozzi@rpgiv.com
Visit the new on-line iSeries Forums at: http://www.rpgiv.com/forum

> -----Original Message-----
> From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]
On
> Behalf Of Ray, Adam
> Sent: Thursday, November 08, 2001 10:10 AM
> To: 'rpg400-l@midrange.com'
> Subject: RE: process a list of files
>
> What gets done with the *'s once they are found has yet to be decided.
The
> reason I need to find them all is because the * (or any special
character)
> can be used as a delimiter when sending files electronically. Any
field
> containing an * will cause whatever program is processing the data to
think
> it's the end of a field when it really isn't. Using a different
delimiter
> has been discussed, but whatever we decide to use, we have to scan for
that
> character in all our files.
> Keep the ideas coming. I'm willing to try just about anything.
> -Adam
>
>
>       Not sure exactly what you are wanting to do with it but I tried
> using PDM's
>       option 25=Find string on a database file and it works by
displaying
> the data
>       in the file containing the * with the found data highlighted.
You
> can then
>       press F16 to "find" other occurrences in the file which will
also be
>       highlighted.
>
>       Selecting option 25 and then pressing F13 while displaying only
> files would
>       at a minimum give you the files that contain the * data.
>
>       If you're thinking many of the files have the * this may not
help at
> all.
>       More details on what you're planning on doing when you find the
data
> would
>       help.
>
>       Lisa
>
>       -----Original Message-----
>       From: Ray, Adam [mailto:ARay@WIPFLI.com]
>       Sent: Thursday, November 08, 2001 10:30 AM
>       To: 'rpg400-l@midrange.com'
>       Subject: process a list of files
>
>
>       I've been stumbling over this for weeks and have decided to
contact
> the
>       experts.
>       I have a long list of files (over 500) that I need to process. I
> need to
>       search every character field in every file for the '*'
character. I
> would
>       like to have one RPG program that will scan the records of the
files
> for the
>       character. But since nearly every file has a different layout, I
> have no
>       idea how to accomplish this. Any ideas are greatly appreciated.
>
>       Thanks,
>       Adam Ray
>       Programmer/Analyst
>       Wipfli Ullrich Bertelson LLP
>       www.wipfli.com <http://www.wipfli.com>
>
>
>
__________________________________________________________________
>
>       Please look below this disclaimer for attachments.
>
>       This email and any files transmitted with it are confidential
and
>       intended solely for the use of the individual or entity to whom
they
>       are addressed. This communication may contain material protected
by
>       attorney-client privilege. If you are not the intended recipient
or
>       the person responsible for delivering the email to the intended
>       recipient, be advised that you have received this email in error
and
>       that any use, dissemination, forwarding, printing, or copying of
> this
>       email is strictly prohibited. If you have received this email in
> error
>       please notify the Information Systems Manager by telephone at
> (715)845-3111
>
>       postmaster@wipfli.com
>       http://www.wipfli.com
>
>
____________________________________________________________________
>
>       This message has been generated by MIMEsweeper. This message and
>       attachments have been swept for all known and recorded computer
> viruses.
>       _______________________________________________
>       This is the RPG programming on the AS400 / iSeries (RPG400-L)
> mailing list
>       To post a message email: RPG400-L@midrange.com
>       To subscribe, unsubscribe, or change list options,
>       visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
>       or email: RPG400-L-request@midrange.com
>       Before posting, please take a moment to review the archives
>       at http://archive.midrange.com/rpg400-l.
>       _______________________________________________
>       This is the RPG programming on the AS400 / iSeries (RPG400-L)
> mailing list
>       To post a message email: RPG400-L@midrange.com
>       To subscribe, unsubscribe, or change list options,
>       visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
>       or email: RPG400-L-request@midrange.com
>       Before posting, please take a moment to review the archives
>       at http://archive.midrange.com/rpg400-l.
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.