Make Array query

[Smithsc]

Within crystal XI, I've got a memo field which contains the following information:
Incomplete:06/05/2010 15:17:00<BR>Corrected:07/05/2010 08:58:00<BR>Incomplete:07/05/2010 12:05:00<BR>Corrected:10/05/2010 09:10:00<BR>

The example above shows 2 instances of Incomplete but there could be 1 instance or 3 or more instances.

What I'm trying to do is create an array that will contain the date/time for each incomplete instance but I can't seem to do it.

Does anyone have any suggestions?

Many Thanks

Stuart.

 

[IanWaterman]

A formula like this will build an array

local stringvar array incomplete:= ["", "", "", ""];
// array will need to be big enough for max possible
Local numbervar n:=1;

While n < count(split(yourmemo, 'Incomplete:'))
do (incomplete[n]:=
left((split(yourmemo, 'Incomplete:')[n+1]), 19);

n:=n+1;

Ian

 

[Smithsc]

Thanks Ian,

One further (probably simple) question.
How do I print the array out?

 

[IanWaterman]

Function Join

Join(incomplete,",")

This will list with comma delimters, however, it will show commas for blank cells too.

Ian