Link to home
Start Free TrialLog in
Avatar of Carlo
CarloFlag for United States of America

asked on

Crystal Reports - A subscript must be between 1 and the size of the array

I am currently running Crystal Reports 2008 and this is the error that I am getting: "A subscript must be between 1 and the size of the array"

This is the data:
Last_Edit = ABERN,11/11/19,16:44,ABERNARDI

I want to just grab the last piece of information after the comma "," which is "ABERNARDI"

This is the code that I have that works but seems like its not perfect.

Split ({Contacts.LAST_EDIT}, ",") [4]

Please advise
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike McCracken
Mike McCracken

Crystal arrays are 1 based.

Is that the only record in the recordset?

It is possible other records don't have 4 columns

mlmcc
Avatar of Carlo

ASKER

The InstrRev worked great Norie. Thanks so much!