RE: having to find an inv. # in a comment field :(

You'd have to add code that after finding the two numbers together that 
the surrounding characters immediately after are numeric of A-Z.  Nice 
catch.

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
709-576-8132
rpower@xxxxxxxxxx
http://www.stjohns.ca/
___________________________________________________________________________
Success is going from failure to failure without a loss of enthusiasm. - 
Sir Winston Churchill




<Matt.Haas@xxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
2006/01/27 04:06 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
<rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: having to find an inv. # in a comment field :(






Except that a comment like "STUPID REQUEST FOR 01/27/06" would generate
a false match.

Matt 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of RPower@xxxxxxxxxx
Sent: Friday, January 27, 2006 2:31 PM
To: RPG programming on the AS400 / iSeries
Cc: RPG programming on the AS400 / iSeries;
rpg400-l-bounces@xxxxxxxxxxxx
Subject: Re: having to find an inv. # in a comment field :(

On my earlier reply, keep it to 2 digits, not 3, I just noticed that
some 
may only contain 2 digits together.  And if you don't find two digits 
together, spit the record out on an exception listing for manual....

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
709-576-8132
rpower@xxxxxxxxxx
http://www.stjohns.ca/
________________________________________________________________________
___
Success is going from failure to failure without a loss of enthusiasm. -

Sir Winston Churchill




steema@xxxxxxxxxxxxx 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
2006/01/27 03:30 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
having to find an inv. # in a comment field :(






Well this is the picture. Don't ask why, but we get some info
from abroad. They put invoice numbers in a comment field. The comment
field can have normal comment info (not invoice number) but when there
is
the invoice there, I need to put this in some other work file.

The len. of this comment field is 40.

It is not uniform. The ways it is there are:

INVOICE# XKC03J143L
INVOICE # XTG05K023L
INVOICE #   XSC06A016L
INV# XKC03G091L
INV. XTC05L053L
INV 5400960
INVOICES XTC05F008L AND XTC05F012L (in this case, I want to write 2 
records)
INVOICE XTC05F009L
INVOICE #'S 2107071, 2107073 & 2107079
INVOICE #'S XSC04H008L & XTC04H021L

IN addition, there are several spelling mistakes on the word Invoice,
but
these are not my concern ( I was thinking how to take the file, run it
in
Microsoft spell check, perhaps someone has done this?).

Any thoughts on the coding would be appreciated.

Thanks,
Steve

INVOICES SHIPPED AFTER COST CHANGE (an example of a real comment)