Crystal XI formula to shorten text

[lorri]

I have a field that is being pulled that I want to summerize. For example I have one field that pulls a drill down of categories ex)
Server.NetApp Filer
Telecommunications.Account Management

I want to write a formula to stop the text at the second period and group totals by that

Is there a formula to shorten this although it's one field?

Any help is great

Thanks

 

[AndyMc]

lorri

Try:

left({table.field),InStrRev({table.field},".")-1)

Andy

 

[AndyMc]

whoops

try

left({table.field},InStrRev({table.field},".")-1)

 

[lorri]

what if I am getting an error that reads string length is less than 0 or not an interger?

If I take out the -1 then it works ok but still leaves on too much text.I only want text.text.

can I do this?

 

[AndyMc]

lorri,
Another way:

StringVar array txt;
txt := split({table.field}, ".");
txt[1] & "." & txt[2]

Andy

 

[lorri]

that gives me an error a subscript must be between 1 and the size of the array

if I take out the txt 2 it works but shortens it too much....thoughts?

Thanks

 

[AndyMc]

It sounds like your field doesn't always have a period.

try:

StringVar array txt;
if instr({table.field},".") = 0 then
{table.field}
else
txt := split({table.field}, ".");
txt[1] & "." & txt[2]

Andy

 

[lorri]

now getting an error at the part after else that this array must be subscripted for example array [i
???
can't get it to work....

 

[AndyMc]

It looks like you need () for the else

StringVar array txt;
if instr({table.field},".") = 0 then
{table.field}
else
(
txt := split({table.field}, ".");
txt[1] & "." & txt[2]
)

Andy

 

[lorri]

when you're good - you're good

Thanks a bunch =)