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
