Resending without the curly quotes. My previous message appeared in the digest as Base 64 encoded.
-----Original Message----- From: Ackerman, Alan Sent: Monday, July 28, 2014 11:44 AM To: [email protected] Subject: RE: [CMS-PIPELINES] Continuation from last post. There is a problem with all these methods -- they can fail if the variable contains any of the special characters of significance to Pipelines or CMS. This would include the stage separator character (usually '|'), the pipe end character (often '?'), and possibly quotes and other special characters. I have a trick to handle this: Replace, for example, '| SPECS /'thishost'/ 1' , '1-* Next', '/'crdate'/ Next' , With '| SPECS' safe(thishost)'/ 1' , '1-* Next', safe(crdate)'/ Next' , Where 'safe' is a REXX function: safe: parse arg str if str == '' then return '$$' /* Change to null */ else return 'x'c2x(str) /* Encode as xAABBCCDD...*/ It would be nice if SPECS had a function to insert a variable value directly, for example: '| SPECS var(thishost) 1' , '1-* Next', 'var(crdate) Next' , Maybe it does and I have missed it? -----Original Message----- From: CMSTSO Pipelines Discussion List [mailto:[email protected]] On Behalf Of Mike Walter Sent: Monday, July 28, 2014 9:45 AM To: [email protected] Subject: Re: [CMS-PIPELINES] Continuation from last post. Miguel, Remove the: '| SPECS /thishost/ 1 ', (that just adds a record with ‘thishost’ before all the other records). Then select any one of these: 1) • After the FANINANY: ‘| INSERT /’thishost’/ BEFORE’ , ‘| INSERT /’crdate’/ AFTER’ , Or 2) • After the FANINANY: ‘| SPECS /’thishost’/ 1’ , ‘1-* Next’, ‘/’crdate’/ Next’ , Or 3) • Change the SPECS stages to: ‘| SPECS /’thishost’/ 1’ , ‘21-28 9 41-48 19 29-32 29', ‘/’crdate’/ Next’ , And: ‘| SPECS /’thishost’/ 1’ , ‘21-28 9 33-40 19 29-32 29', ‘/’crdate’/ Next’ , Three choices -- the last is most efficient, but the others broaden your exposure to Pipes. If you need a space after ‘thishost’, change ‘Next’ to ‘Nextword’, if you need a space before ‘crdate’, again change its ‘Next’ to ‘Nextword’. Mike Walter Aon Corporation The opinions expressed herein are mine alone, not necessarily those of my employer. -----Original Message----- From: CMSTSO Pipelines Discussion List [mailto:[email protected]] On Behalf Of Miguel Soltero Diaz Sent: Monday, July 28, 2014 11:21 To: [email protected] Subject: Re: Continuation from last post. Hi guys, I hit the send bottom too soon... Basically I need to add the result of a CMS command at the beginning of each record, and current date at the end of the record (or viceversa). I want to execute the commands only ones, place them in a variable and insert those variables in the pipe, before and after the SPECS ... crdate = date(standard) say 'date is ' crdate thishost = strip(VMINQ(vmhost)) say 'host is ' thishost 'pipe (endchar ?)', '< AUDIT EXTRCT1', '| a1: locate (29-32) /0690/ ', '| specs 21-28 9 41-48 19 29-32 29 ', '| b: faninany', '| > AUDIT SUBset3 A', '? a1:', '| a2: locate (29-32) /1090/ ', '| SPECS 21-28 9 33-40 19 29-32 29', '| b: ' would like to insert THISHOST to the beginning of each record and CRDATE at the end of the same... How can I do this? Thank you... Miguel ---------------------------------------------------------------------- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message.
