TRIM Function 1

[mrshardee2]

I have the following field that I am pulling into a report (Crystal 8.5):

/O=srmc/OU=SRMCNTNET/cn=Recipients/cn=Hunt36

I want to trim the field to only show what is after the 4th "=" sign. Seems like it should be fairly straightforward.

Any help would be appreciated.

Thanks!
Amber

 

[lbass]

Try:

mid({table.field},instrrev({table.field},"=")+1)

-LB

 

[bdreed35]

Will there always be 4 "=" signs in the field? Do you always want the 4th one or the last one?

An alternative to lbass's solution would be to use the split function. Create the following as a formula:

split({table.field},"=")[5]

~Brian

 

[mrshardee2]

There should always be four "=" signs. lbass, your suggestion worked! Thanks!

Thanks bdreed35, too!

Amber