Hi, Jim. Do the input records always have the $KEY$ field in them?
DJ On 08/12/2014 12:12 PM, James Vincent wrote: > Hello everyone, > > Would anyone have ideas on how I can extract data out of a record based on > a keyword that could be anywhere within the record? > > For instance, given the data: > > 0001 data$blah$blah$data$KEY$BETTER$data$data$data$blah > 0002 data$blah$blah$data$data$data$data$blah$KEY$MOREBETTER$data$data > > I'd like to get to: > > 0001 BETTER > 0002 MOREBETTER > > I'm toying with SPLIT but wondered if I'm making this too hard. Any > thoughts? > > -- *James Vincent* > -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544
