Hi Joris, I have recently found myself in the same predicament and it is kind of crappy. I have found the same limitations as you Array Max = 1000, String Max = ~65K characters. Admittedly this is a workaround but I think it is a nice one. What you could do is create sting array and combine the elements using a character separator (e.g. ';'), once the length in each array element reaches a certain size you would then move onto the next array element. I have developed some code in Crystal XI V2 that builds this combined string array, see below. There are however a few things to consider:
Firstly, this will increase processing time.
Secondly this code will increase memory usage.
Thirdly, depending on what you are using it for you would need advanced string analysis and/or data conversion to get the data out.
Lastly this code could potentially store up to 65million characters (1,000 x 65,000).
Hope this helps?
SHARED STRINGVAR ARRAY holdArray_DealRef;
SHARED NUMBERVAR k;
LOCAL STRINGVAR holdString;
/// Only want to hold 'Cheese' deals in string array.
IF LEFT({Table.DealReference}, 6) = 'Cheese' THEN
(
IF k = 0 THEN
(
k := 1; /// Sets k at 1 for the start.
holdString := {Table.DealReference};
Redim Preserve holdArray_DealRef[k];
holdArray_DealRef[k] := holdString;
)
ELSE
(
holdString := holdArray_DealRef[k];
/// The reason that an array is built from concatenated strings is to get around the Crystal limitations.
/// The limit for any array is 1000 items.
/// The limit for any string variable is just over 65,000 characters.
IF LEN(holdString) > 32000 THEN /// This could easily be up to ~65,000 characters.
(
k := k + 1;
Redim Preserve holdArray_DealRef[k];
holdString := {Table.DealReference};
holdArray_DealRef[k] := holdString;
)
ELSE
(
holdString := holdString & ';' & {Table.DealReference};
holdArray_DealRef[k] := holdString;
);
);
);
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.