I had a formula that looked like this in a column of a view:
bulletinslist := @UpperCase(“#JACK'S COMMENTS” : “#ATE DIVISION” : “#ATE_DIVISION” : “#COMMUNICATIONS” : “corporate PLANNING” : “corporate OPERATIONS” : “#FINANCE AND ADMINISTRATION” : “#HUMAN RESOURCES” : “#MILITARY PRODUCTS” : “#POWER MANAGEMENT PRODUCTS” : “#PROTECTION PRODUCTS” : “#QUALITY ASSURANCE” :“#SALES AND MARKETING” : “test” : “#USAR” : “##ccMTA” : “#HID & System Management”) ;
tmpSendTo := @ReplaceSubstring( @UpperCase(SendTo) ; “@DOMAIN” : “@DOMAIN.COM”; “”) ;
tmpCopyTo := @ReplaceSubstring( @UpperCase(CopyTo) ; “@DOMAIN” : “@DOMAIN.COM”; “”) ;
tmpST := @ReplaceSubstring( @UpperCase(tmpSendTo) ; “ATE_” ; "ATE ") ;
tmpCT := @ReplaceSubstring( @UpperCase(tmpCopyTo) ; “ATE_” ; "ATE ") ;
resultslist1:=@Keywords(bulletinslist; @Explode(tmpST)) ;
resultslist2:=@Keywords(bulletinslist; @Explode(tmpCT)) ;
@If(@Implode(resultslist1:resultslist2)=NULL ; “_Bulletin Board Not Specified” ; @Trim(@Implode(resultslist1):@Implode(resultslist2)) )
It returned values like this as the categories in my column (which match the values in the bulletinslist field):
#JACK’S COMMENTS
#SALES AND MARKETING
#POWER MANAGEMENT PRODUCTS, etc etc
This same formula now returns:
AND #SALES MARKETING
PRODUCTS #POWER MANAGEMENT
#JACK’S COMMENTS
HELP!! Nothing in the documentation explains why this no longer works, Implode/Explode do not appear to be the culprit, it appears it is the Keyword function (I know this by the fact that I broke down the formula piece by piece and it is not until I add in the Keyword that it breaks down).
I have tried hard coding delimeters into the explode and implode and it gets even worse.
I searched through this forum and through the release notes, but nothing indicates that any of these functions should have changed.