This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


Oct 9, 2015, 8:11 PM
4 Posts

Column on View to show only Internet Addresses

  • Category: Administration
  • Platform: Windows
  • Release: 9.0.1
  • Role: Developer
  • Tags:
  • Replies: 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

Oct 10, 2015, 1:15 AM
43 Posts
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.


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal