Extracting text

[1chicken]

String= hi : how : are : you

Would like to extract text between x set of parentheses.

???

 

[synapsevampire]

There aren't any parentheses?

To extract text between some standard delimiter, consider using a formula containing something like:

whileprintingrecords;
stringvar array MyArry := split("hi : how : are : you",":"
join (MyArry,"&quot

In CR 8.5 or less you'll be gated by a 254 character limit.

-k

 

[1chicken]

Sorry, I meant :'s.
(You probably figured that out.

Actually looking to extract one of these words from between the :'s. Ex.

In each detail line the length of the string may be different, however, I want to extract the second word regardless of char length.

Thanks for your help.

Robb

 

[dgillz]

The following should work:

whileprintingrecords;
stringvar array MyArry := split("hi : how : are : you",":"
myArray[2];



Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[1chicken]

While I'm at it, I may as well ask:

Is there a way to join rows of detail into one field in the group header? Ex.:

GH1=Animals
D=CAT
D=DOG
D=MOUSE

desired result:

GH1=Animals CAT DOG MOUSE

and thanks for your help on the others!