How to pick last word from a text

[devnaren]

Hi All,

I want to write a formula in such a way tht it should pick last word from a text.

for eg:

"AccNo/100045/DVS/John Smith"

Now I want "John Smith" from above word.

Can anyone help me out how to get tht word from a long text.

 

[lbass]

Create a formula:

if instr({table.string},"/") > 0 then
split({table.string},"/")[ubound(split({table.string},"/"))] else
{table.string}

-LB

 

[devnaren]

It works perfect.

Thanks a lot Lbass.

 

[IdoMillet]

Not that it matters much, but I think than a simpler version should work just as well:

split({table.string},"/")[ubound(split({table.string},"/"))]

In other words, no need to test for "/".

Cheers,
- Ido



view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

Ido is correct.

-LB

 

[devnaren]

Thanks guyz