A Concatenation Rule

Decription

This rule is used to take a value from two folders and combine them. The result is placed in the [Net Location] folder so that ECCO can directly access the file. The two folders are [Folder] and [File Name] where [Folder] is intended to contain the full directory location of the file and [File Name] is the name of the file in the directory. For instance N1 ABE-SDC Meeting 1 draft agenda R3.doc is the file name in the folder "J:\regs_standards\Accessible Built Environment\General\" the quotes are required as there may be spaces in the string and ecco will not recognize the complete string without the quotes.

Rule Description

iff([File Name]=="","",'"'+substr([Folder],2,len([Folder])-2)+[File Name]+'"'):[Location]="Server"

This rule creates a string that starts and ends with the addition of a single quote so that the ecco will recognize the entire string when it launches the item. This is done by the ' " ' to force the quote into the string.

iff([File Name]=="",
/*an if statement that determines if [File Name] has value

"",
/*null is returned if true otherwise

'"'+substr([Folder],
/*the substring of the [Folder] is extracted, the quotes are stripped off

2,len([Folder])-2)+
/*the quotes are stripped off

[File Name]+'"')
/*the [File Name] is added to the string

:[Location]="Server"
/*this rule only is applied if the [Location] folder value equals "Server"