I am running a report in Crystal Reports v8.5 that contains a formula
which splits the name field in the database into first, last and MI
for purposes of importing into another database.  The formula was
written by a crystal tech for me and worked fine UNTIL I had to
replace my harddrive and reinstall everything from scratch.  I saved
all the data, but of course had to reinstall all of the programs.  Now
every time I try to run the report, the formula editor pops open with
the error "a subscript must be between 1 and the size of the array -
OK" error displayed.  When I clear the error message and click on the
check formula button it returns "no errors found."  I'm using crystal
syntax.  I tried switching it to basic, but got immediate error
messages.
Can anyone help?

When you check the validity of a Formula, the program usually only
checks the _syntax_ to make sure the language is legal, and not the
context of elements in it, since this depends on what information the
report is being run against.

If you could post the formula and a very short summary of what the
formula is used for, we could have a better idea of what's causing it,
and how to solve it.

Here is the formula.  There is some info on how the data is stored
below the formula.

stringvar firstn:=split({PYEmployees.Name},",")[2];
numbervar lngth:= len({PYEmployees.Name});
numbervar fn:= Instr({PYEmployees.Name},",") + 2;
Stringvar fnandmid:={PYEmployees.Name}[fn to lngth];
numbervar md:=instr(fnandmid," ");
numbervar lngth2:= len(fnandmid);
If md>0 then Stringvar midname:= fnandmid[md to lngth2] else "";

The formula breaks the name stored in a single field in the database
into its component parts.

The names in the database name field are in the format
Lastname, Firstname MI.
if there is a Jr or III or something, it would be
Lastname suffix, Firstnam MI.
In many cases there are hypenated lastnames and/or no middle name
and/or the middle name is spelled out rather than an initial.

In Crystal, if you subscript a string and the string is not as long as
that subscript, you will get that error.  If you say {stringfield}[5]
and {stringfield} is less than 5 characters long, you will get the
described error.  You will need to add more 'if then' stuff to your
formula to ensure each part is at least as long as the lower
subscript.  I don't think Crystal minds if you subscript beyond the
end of the string.

J