Can't get output I need 1

[gneboardin]

I am pulling information from a specific field in a Lotus Notes DB. The field is a Referral Source field and can contain names of people from the "company" address book in Lotus Notes and can also contain free form names that aren't part of the company.

When showing the field in my report, it registers an error and won't show the names that aren't from within the address book.

Example of Field: Bob Smith/Nowhere Bank, Jane Doe/Nowhere Bank, Mike User, Sarah User

It will only show the Bob Smith and Jane Doe.

Does anyone know of a function I can use to show name IF on company address book, if not in address book then show anyway?

Please help

 

[Madawc]

Are you linking from a list of people to a reference that may not exist, the "Nowhere Bank" field?

In that case, check your link. An equals from people to ref will exclude those without ref. A 'Left Outer' will allow them.

Note also that if you do any test on a field from 'ref', it must include the possibility of the field being null. And null must always be the first thing you test for, since it otherwise stops on encountering a null.

Madawc Williams (East Anglia, UK)

 

[gneboardin]

I'm not really following what you mean. Again, I am a novice so it may just be over my head.

The Referral Field I'm pulling from contains information of this nature:

Refd by: CN=Jane Doe/O=Nowhere Bank, CN=Bob Smith/O=Nowhere Bank, Mike User, Sarah User

If I pull the field right into the report that is how it looks. However,I need to report the names minus the CN= and the O=Nowhere Bank. The code I had to do that did take that out but then won't show just the plain names Mike User, Sarah User because they dind't have that info in their name to begin with.

Can someone show me a simpler code to strip the info I need and still show the other names

 

[lbass]

Try using:

replace(replace({table.string},"CN=",""),"/O=Nowhere Bank","")

This should work in CR versions 8.5+. This would only work if the company name is always the same. If it can vary, please provide a sample of the variations in this string field.

-LB

 

[gneboardin]

I tried that but it didn't seem to work...still reading with the CN=

 

[lbass]

What version of CR are you using?

-LB

 

[gneboardin]

9.0

 

[lbass]

How about posting your exact formula here, since my suggestion should work...

-LB

 

[gneboardin]

Your suggestion did work. I'm sorry I must have done something wrong with my initial grouping when I used the formula...

Thanks very much for your help