subscript must be... error

[aspnetuser]

I get the subscript must be between 1 and the size of the array using the following formula.

stringvar State := split(trim(split({CSZ},",")[2])," ")[1];

CR 8.5

It works for the records it returns how do i solve the error?

 

[vidru]

That probably means you've got some {CSZ}'s that don't have a comma. Perhaps you can add a check for a comma before attempting to use Split:

StringVar State;
If InStr({CSZ},",") = 0 then
State := "Unknown"
Else
State := split(trim(split({CSZ},",")[2])," ")[1];

-dave