Or you could use "strfind /.../" in place of the "find ...". This also handles the blank that Rexx adds for the continuation, and it even works on the distributed Pipelines.
Regards, Richard Schuh > -----Original Message----- > From: CMSTSO Pipelines Discussion List > [mailto:[email protected]] On Behalf Of Hughes, Jim > Sent: Friday, August 20, 2010 1:08 PM > To: [email protected] > Subject: Re: Null/blank value > > I like > > PICK 1+ == /Your string goes here/ instead of FIND > > ____________________ > Jim Hughes > 603-271-5586 > "It is fun to do the impossible." > > -----Original Message----- > From: CMSTSO Pipelines Discussion List > [mailto:[email protected]] On Behalf Of Frank M. Ramaekers > Sent: Friday, August 20, 2010 4:04 PM > To: [email protected] > Subject: Re: [CMS-PIPELINES] Null/blank value > > 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]. >
