For varying values of always. My approach would probably to split in field and do things with between our inside. On Aug 12, 2014 7:23 PM, "James Vincent" <jamesscottvinc...@gmail.com> wrote:
> Yes, I should have mentioned the keyword will always be the same. So for > my example, $KEY$ is the keyword. The "BETTER" and "MOREBETTER" parts can > be any data. > > > -- *James Vincent* > -- President, SHARE Inc. > -- Calendar: http://tinyurl.com/JSVCalWeek > > > On Tue, Aug 12, 2014 at 1:19 PM, Dave Jones <d...@vsoft-software.com> > wrote: > > > 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 > > >