Lotus and bad formula

Hello,

I found an formula to intranet IBM and it’is an bad formula with a Bug !!

Please can you help me

This formula it’s

@URLOpen(“http://w3.ibm.com/bluepages/simpleSearch.wss?searchBy=Name&location=All+locations&searchFor=” + @Name([Abbreviate];Principal))

There are a bug but where is the Bug ??

This formula allows you to view the sender of an e-mail on Blupages

Thanks

Michel

Subject: LOTUS AND BAD FORMULA

What is the error you’re getting?

This is only a guess, but URL’s don’t like spaces, therefore there would be a problem if the persons name has a space in it.

IF that is the problem then change it to:

@URLOpen(“http://w3.ibm.com/bluepages/simpleSearch.wss?searchBy=Name&location=All+locations&searchFor=” + @ReplaceSubstring(@Name([Abbreviate];Principal); " "; “+”) )

Subject: RE: LOTUS AND BAD FORMULA

Thank you for your answer, but in fact it is necessary to delete the characters behind the name No results were found for Name: “Bernard Vaillant / France / Control / IBM.”

and I don’t know how

See you later

Michel

Subject: LOTUS AND BAD FORMULA

Your search criteria is wrong. You need to pass the parm for searching a Notes email address. Do a bluepages name search using Notes Email as search type and you will see the url format. Beyond that you need to also replace the ‘/’ in the Notes name with its hex value.