you'll have to debug what I did wrong.
standard way to check is to break the formula into one or more new formulas and display only part and check that the output of the formula matches what you want it to.
for example, create a formula with this in it:
local stringvar ls := {table.field};
local numbervar x;
x := instr(ls, "(");
x
and see if the value display matches the location of the "(", if the value is 0 and there is a ( in the field then replace the last x with ls and see if the column is correct. If everything matches, add another line in and see if the results of that line match with expectations.
HTH
OK, I see what I did wrong... should be ls := xxx
:= is the assignment operator, = is the comparator.
Edited by lockwelle - 10 Apr 2012 at 7:54am
IP Logged
