Vantage Crystal "split" problem

Yahoo Archive
1
Sorry, it's chr(13).

Here is a working example. Put this in a formula field. Place the formula
field in your report and make sure that the "can grow" checkbox is checked.



local stringvar
entrylist:="joe,carol,sean,sarah,laura,maureen,andrew,sydney,claudia,owen,ba
iley";

shared stringVar array entlist:=split(entrylist,",");

local numbervar i;

local stringvar returnvalue;

for i := 1 to ubound(entlist) do(

returnvalue:=returnvalue & entlist[i] & chr(13);

);

returnvalue;



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sean McDaniel
Sent: Sunday, March 08, 2009 11:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Vantage Crystal "split" problem



Loop through the array concatenating each item with & chr(15) return this
string.

-----Original Message-----
From: k2lamm <karl_a_lamm@...
<mailto:karl_a_lamm%40lesueurinc.com> >
Sent: Sunday, March 08, 2009 9:48 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Vantage Crystal "split" problem

I'm sorry... I am a newbie with Crystal. I understand your reply but still
do not know how to get this string of comma separated values to
display/print with each entry being on a separate line. Any additional help
would be greatly appreciated.
Thanks.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
McDaniel" <smcdanie@...> wrote:
>
> This example places your values in the shared array entlist. No limit on
the
> dimension of the array.
>
> You can't return an array from a function like this so you need to return
> something other than an array, in this case an empty string.
>
>
>
> shared stringVar array entlist:=split({security.entrylist},",");
>
> ""
>
>
>

[The entire original message is not included]





[Non-text portions of this message have been removed]
2
I found this code and reworked it for my situation. I am retrieving a Vantage table where I will find any number of entries in the form of a string with a comma used as a separator. I want a Crystal report that will show all of these entries in a more readable fashion. When I setup the formula I end up with a boolean result field. Any ideas?

shared stringVar array entlist;
redim entlist[10];
numberVar i;
numberVar j;
numberVar top := ubound(split({security.entrylist}));
for i := 1 to top do
(
entlist[i] := split({security.entrylist},',')[i];
);

if top < 10 then
(
for j := top+1 to 10 do
(
entlist[i] := '0';
)
);
3
This example places your values in the shared array entlist. No limit on the
dimension of the array.

You can't return an array from a function like this so you need to return
something other than an array, in this case an empty string.



shared stringVar array entlist:=split({security.entrylist},",");

""





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
k2lamm
Sent: Friday, March 06, 2009 5:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage Crystal "split" problem



I found this code and reworked it for my situation. I am retrieving a
Vantage table where I will find any number of entries in the form of a
string with a comma used as a separator. I want a Crystal report that will
show all of these entries in a more readable fashion. When I setup the
formula I end up with a boolean result field. Any ideas?

shared stringVar array entlist;
redim entlist[10];
numberVar i;
numberVar j;
numberVar top := ubound(split({security.entrylist}));
for i := 1 to top do
(
entlist[i] := split({security.entrylist},',')[i];
);

if top < 10 then
(
for j := top+1 to 10 do
(
entlist[i] := '0';
)
);





[Non-text portions of this message have been removed]
4
I'm sorry... I am a newbie with Crystal. I understand your reply but still do not know how to get this string of comma separated values to display/print with each entry being on a separate line. Any additional help would be greatly appreciated.
Thanks.
--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdanie@...> wrote:
>
> This example places your values in the shared array entlist. No limit on the
> dimension of the array.
>
> You can't return an array from a function like this so you need to return
> something other than an array, in this case an empty string.
>
>
>
> shared stringVar array entlist:=split({security.entrylist},",");
>
> ""
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> k2lamm
> Sent: Friday, March 06, 2009 5:28 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Vantage Crystal "split" problem
>
>
>
> I found this code and reworked it for my situation. I am retrieving a
> Vantage table where I will find any number of entries in the form of a
> string with a comma used as a separator. I want a Crystal report that will
> show all of these entries in a more readable fashion. When I setup the
> formula I end up with a boolean result field. Any ideas?
>
> shared stringVar array entlist;
> redim entlist[10];
> numberVar i;
> numberVar j;
> numberVar top := ubound(split({security.entrylist}));
> for i := 1 to top do
> (
> entlist[i] := split({security.entrylist},',')[i];
> );
>
> if top < 10 then
> (
> for j := top+1 to 10 do
> (
> entlist[i] := '0';
> )
> );
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Loop through the array concatenating each item with & chr(15) return this string.

-----Original Message-----
From: k2lamm <karl_a_lamm@...>
Sent: Sunday, March 08, 2009 9:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage Crystal "split" problem

I'm sorry... I am a newbie with Crystal. I understand your reply but still do not know how to get this string of comma separated values to display/print with each entry being on a separate line. Any additional help would be greatly appreciated.
Thanks.
--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdanie@...> wrote:
>
> This example places your values in the shared array entlist. No limit on the
> dimension of the array.
>
> You can't return an array from a function like this so you need to return
> something other than an array, in this case an empty string.
>
>
>
> shared stringVar array entlist:=split({security.entrylist},",");
>
> ""
>
>
>


[The entire original message is not included]