How to split a string and make an array of integer

Question

I have a string with set of employee IDs separated by an _(Underscore). What i want to do is to split that into separate strings and convert them to integers and save them in an integer array. Is this possible in Crystal Reports? Is it possible to convert string into integer/number in Crystal Report?

I have tried using split function but still couldn't figure out how to use it to create an array.

I am very new to crystal report it would be a great help if you could help me out.

Answer 1

//create an array of strings by parsing a underscore-delimited string field
Stringvar Array strings := Split({table.string_field}, "_");

//empty numeric array; sized to match
Numbervar Array numbers;
Redim numbers[Ubound(strings)];

//populate array
Numbervar i;
for i := 1 to Ubound(strings) do (
  numbers[i] := ToNumber(strings[i])
);

//return
numbers;

Answer 2

split is the correct function. i think it will probably be easiest to keep them as strings and then convert when you need to use them (otherwise you will simply have to loop through the string array and populate a new number array).

what trouble are you having with split? and what do you then intend to do with your array?