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*
