And I guess that I was a stubborn one, I started coding years ago with the stagesep on the right, at the end, rather than at the beginning left, and never changed that style. Works well for me in this particular instance (and others):
'em: find Phone|', 'spec 9-* n /;/ n |', 'fin:', '\ em: |', 'find email|', 'spec 9-* n |', etc... But I don't suppose I'll be changing anyone's choice of style today with this example, I find that every plumber I meet is as stubborn as I am when it comes to their style choice... John -----Original Message----- From: CMSTSO Pipelines Discussion List [mailto:[email protected]] On Behalf Of Kris Buelens Sent: Friday, August 20, 2010 1:13 PM To: [email protected] Subject: Re: Null/blank value I guess you'd better code '| em: StrFIND /Phone:_/', With StrFind you are independant on how the REXX code is written. With a simple FIND these are all different '| em: FIND Phone'||, '|xxx --------- '| em: FIND Phone', '|xxx --------- ' | em: FIND Phone'||, ' |xxx --------- ' | em: FIND Phone', ' |xxx The last example looks for records starting with Phone and at least 3 other characters. 2010/8/20 Frank M. Ramaekers <[email protected]> > I noticed that as well. > > '| em: FIND Phone'||, > > This will match each line that starts with 'Phone' > > Yours will match 'Phone ' 'Phonexx' 'Phone??' (blanks are wildcards). > > Frank M. Ramaekers Jr. > > > > -----Original Message----- > From: CMSTSO Pipelines Discussion List > [mailto:[email protected]] On Behalf Of Larson, John E. > Sent: Friday, August 20, 2010 2:54 PM > To: [email protected] > Subject: Re: [CMS-PIPELINES] Null/blank value > > Did you intentionally put a space/blank on all of your FIND statements? > > '| em: find Phone ', > '| spec 9-* n /;/ n', > '| fin:', > '\ em:', > '| find email ', > '| spec 9-* n', > > Seems that the space between Phone and the ' mark implies a field must > be present or the FIND will not match. > > JL > > -----Original Message----- > From: CMSTSO Pipelines Discussion List > [mailto:[email protected]] On Behalf Of Mark Pace > Sent: Friday, August 20, 2010 12:39 PM > To: [email protected] > Subject: Null/blank value > > I have a file that contains my customer information formated as such > FORM: Customer > Customer_Name: Some Customer1 > SysProg: Jane Doe > Phone: xxx.xxx.xxxx > email: [email protected] > $UpdatedBy: CN=Mark Pace/O=Mainline > > " > FORM: Customer > Customer_Name: Some Customer2 > SysProg: John Doe > Phone: > email: [email protected] > $UpdatedBy: CN=Mark Pace/O=Mainline > > I want to put it in a file as such > Some Customer1*;*Jane Doe*;*xxx.xxx.xxxx*;*[email protected] > So basically a CVS file using an *;* as the delimiter. > > I have this pipe > 'PIPE (end \ name TTCUST.EXEC:12)', > '|< ttcust data a ', > '| sy: find Customer ', > '| spec 17-* 1 /;/ n', > '| fin: faninany', > '| > ttcust data2 a', > '\ sy:', > '| ph: find SysProg ', > '| spec 11-* n /;/ n ', > '| fin:', > '\ ph:', > '| em: find Phone ', > '| spec 9-* n /;/ n', > '| fin:', > '\ em:', > '| find email ', > '| spec 9-* n', > '| fin:' > > And it mostly works. If a field is missing I would expect a record > with only a ; delimiter, but I am getting nothing, the field is just missing. > I realize in the test exec that each filed comes out as a seperate > line and I only have to do a JOIN after the faninany to create the one > record. > My question is why I don't get a record if say the phone number is > blank? > > > -- > Mark D Pace > Senior Systems Engineer > Mainline Information Systems > > _____________________________________________________ > This message contains information which is privileged and confidential > and is solely for the use of the intended recipient. If you are not > the intended recipient, be aware that any review, disclosure, copying, > distribution, or use of the contents of this message is strictly > prohibited. If you have received this in error, please destroy it > immediately and notify us at [email protected]. > -- Kris Buelens, IBM Belgium, VM customer support
