Grouping on first word of a field

[TEM3]

Using Crystal Reports 8.5 and Oracle 9i tables:

I have a table with a text field ("{Asset Name}") where, for the most part, the first word indicates the manufacturer. I wish to create groups from the first word.

Is there a function to pull off the first word/string before a space in a text field?

 

[Turkbear]

Hi,
Yes there is..

Oh, you probably would like to know what it is right?

Try:

@GroupOnThis
{Asset Name}[1 to (Instr({Asset Name},' ') - 1)]



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[TEM3]

I was attempting to do the same useing the "Split" function, but could not make it work. Thanks.

Now a few of the records are just one word. Not sure how Oracle pads the field, but do you think your formula will hands those records too?

 

[lbass]

You could use split:

if ubound(split({table.field}," ")) > 1 then
split({table.field}," ")[1] else
{table.field}

-LB

 

[Turkbear]

Hi,
LB's solution will work better with one word field data since my formula would not find a space ( unless it is an Oracle CHAR field ( instead of varchar2) and has added spaces after the end of the string) and would then try to substring from 1 to -1 - not likely to work..





To Paraphrase:"The Help you get is proportional to the Help you give.."