Hi

I have a field (assessment) where the data looks simialr to this

@@T_098_ = "abc"@@T_099_ = "def"@@T_100_ = "ghi"@@T_101_ ="jkl "...etc

I need to figure out a formula to get whats in between the qoutes

for example I need just abc which is between @@T_098_ = " and  "@@T_099_ = "

Hope it makes sense and thanks

if it is truly embedded quotation marks, you could try something like:
local stringvar result :="";
local numbervar index;
local booleanvar flag := false;
for index:=1 to len({table.field}) do(
if instr({table.field}, index,1) = chrw(34) then
    flag = not flag   //flip the flag (true, want, false ignore
else
    if flag = true then
      result := result + instr({table.field}, index, 1)
);
result


it should work. there is probably a more elegant method using instr and mid, but this seems the most straight forward. I like Split() and it should work. I would probably split the field then concatenate all the even values (if that is what you are after).

Either way, hope one of these ways works for you.