Extracting First Word in String

[joshwilson1]

I using Crystal Reports 9 and am connected to a SQL Server 2000 DB. I am trying to get the first whole word in each string to use as the Group Title. For example, with Adobe Acrobat 5.0 CD, I want to return Adobe into the Group name. I have tried to use a For loop but it returns the whole string minus any spaces. Here is the formula:

Local StringVar str := "";
Local NumberVar strLen := Length ({Software.Software});
Local NumberVar i;
For i := 1 To strLen Do
(

if {Software.Software} <> " " then
str := str + {Software.Software}
else
str
);
str

Does anybody know the proper formula to make this work? Thanks for any help.

 

[IdoMillet]

Use:

Split({Software.Software}, " ")[1]

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com