if Name = previous(Name) then "Y"

 

Since that will only look at the previous return, I am limited to them side-by-side.  Is there something that can be written to set the flag if it matches any of the returns?  I was going to sort by that Name field, but the listing needs to be in a specific sort order (sequential).

 

Any help is greatly appreciated.

 

Thank you so much.  That worked perfectly.

shared stringvar allNames;

shared stringvar rec;

local numbervar ind :=  instr(allNames, "|" + Name + "^");

local numbervar carat;

 

if ind>0 then (

  carat := instr(ind, allNames, "^");

  ind := instr(carat, allNames, "|");

  rec := mid(allNames, carat+1,  ind - carat - 2);

  "Y"

)

else(

  allNames := allNames +  "|" + Name + "^" + RecordNumber;

  "N"//or could be "" the empty string

)

 

then in another formula you can access the recordNumber via

shared stringvar rec

 

Glad I could help.

 

shared stringvar allNames;
shared stringvar rec;
local numbervar ind :=  instr(allNames, "|" + Name + "^");
local numbervar carat;

if ind>0 then (
  carat := instr(ind, allNames, "^");
  ind := instr(carat, allNames, "|");
  if carat > ind then (
    rec := mid(allNames, carat+1,  carat - ind - 2);
    "Y";
  ) else(
    rec := mid(allNames, carat+1,  ind - carat - 1);
    "Y";
  )
)
else(
  allNames := allNames +  "|" + Name + "^" + RecordNumber;
  ""
)