Well, there is CHOP BEFORE string /xxx/ | CHOP AFTER string /xxx/|...|PICK 1+ == ?BETTER?, ?MORE..
On 12/08/14 19:12, 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*