Column on View to show only Internet Addresses

HCL Domino Domino Forum
1

Greetings,

On a Names field in a document I have the following values:

CN=Test User/OU=Test/O=MyOrganization
Test User
CN=Test User/OU=OLDTest/O=MyOrganization
test.user@mydomail.com
tuser@mydomain2.com

How do I get a column in a view to only show the Internet address, like:
test.user@mydomail.com, tuser@mydomain2.com

Any help is appreciated

2

Subject: Please refer to Help if any syntax error is found

Not having access to a designer right now but the logic would be as follow

  1. Loop through all value on that field

  2. If it contain “@” then add into another variable

Assuming that field name is Internet Field then the code would be similar to :

NewField := “”;

@For(i:= 0; i < @Elements(InternetField); i := i + 1; @Do(

@If(@Contains(InternetField[i]; “@”); NewField := NewField : InternetField[i]; “”)

));

@Trim(NewField);

Beware that the above formula might throw an error due to typos and incorrect syntax.