Miguel, Sir Rob The Plumber is one of z/VM's "Master Plumbers", and a generous VM Community contributor.
With some explanatory comments (stage names and arguments UPPERCASE to distinguish them from variable text, default arguments included) , Rob's sample again: ‘PIPE (ENDCHAR ?)’ , ‘| < input file fm’ , /* Primary input to LOOKUP are the “DETAIL” records */ ‘| L: LOOKUP NOPAD 29.4 1.4 DETAIL’ , /* Look in column 1 for 4 chars for record with any of the strings passed from the LITERAL stage */ , /* Keep only the DETAIL records with matching MASTER records (from below) in cols 1 for 4 */ ‘| CONSOLE’ , /* Display the results on the console, you can change this to write to a file, etc. */ ‘? LITERAL 0690 1090 nnnn’ , /* Add more 4-char codes in place of the ‘nnnn’ */ ‘| SPLIT AT BLANK’ , /* Split the literal at into separate records ‘ | L:’ /* Shunt that “MASTER” records to the label “L:” as the secondary input to LOOKUP */ 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:CMS-PIPELINES@VM.MARIST.EDU] On Behalf Of Miguel Soltero Diaz Sent: Wednesday, July 23, 2014 17:12 To: CMS-PIPELINES@VM.MARIST.EDU Subject: Re: Trying to use the Locate Thanks Rob... Need to read first about lookup... not following ... yet :) You guys are that efficient always? LOL Miguel