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].
