hopefully the list isn't long, you could try something like:
local numbervar iIndex;
local stringvar displayMe;
iIndex := instr({table.field}, "red fox");
if iIndex > 0 then
displayMe := mid({table.field}, iIndex, len("red fox");
this should give you the gist of how to do what you are after. instr to find the starting point of the string and len to figure out the how many characters to use.
to go between 2 set numbers like from quick to the end of jumped, I would try:
local numbervar iStart;
local numbevar iEnd;
iStart := instr({table.field}, "quick");
if iStart > 0 then (
iEnd := instr({table.field}, "jumped");
mid({table.field}, iStart, iEnd + len("jumped") - iStart + 1
HTH
IP Logged
