A not found condition will not generate a blank record (this is why your not getting these fields. To allow for this, you should (for example):
'| ph: find SysProg ', '| APPEND LITERAL ', '| TAKE FIRST 1', '| SPEC 11-* 1 /;/ n', '| fin:', This will insure at least one record is in the stream Frank M. Ramaekers Jr. -----Original Message----- From: CMSTSO Pipelines Discussion List [mailto:[email protected]] On Behalf Of Mark Pace Sent: Friday, August 20, 2010 2:39 PM To: [email protected] Subject: [CMS-PIPELINES] 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].
