Highlighting Multiple Selections

[James Gill]

I recently stumbled across a method of highlighting multiple selections that is relatively easy to use, however, as I did not create the actual method, I'm still trying to figure out exactly how it works.

Basically, (and in my limited understanding) what this method does is take the value of the whatever field you define adds it to either a field or variable (in my case I'm using a variable). When you click on another record it records the current values in the variable and then adds the new record's content to the calculation using pilcrows. If you click on a record whose contents are already in the calculation, it removes it.

The problem (and I'm not sure if this is a result of an error in the calc or a limitation of this method) is that it is leaving empty pilcrow symbols in the variable. I'm trying to perform some custom formatting using this method and cannot do this if the calc doesn't actually remove all of the contents it's putting in.

I hope I described the problem accurately enough. Here is the calc in question:

Case ( 

FilterValues ( <$$GlobalVariable> ; )

; Substitute (¶ & <$$GlobalVariable> & ¶ ; ¶ &  & ¶ ; ¶ )

; <$$GlobalVariable>  & ¶ & 

)

tl;dr version: I don't quite yet have a mastery of Substitute and FilterValues commands and don't know what this stupid thing is doing.

[Vaughan]

Where did you find this technique?

[bruceR]

Known problem with that technique. Returns need to be addressed. See update.

http://www.briandunning.com/cf/987

[comment]

See also:

http://fmforums.com/forum/showtopic.php?tid/216082/post/362620/#362620

[James Gill]

Brian Dunning's CF worked great! Thanks guys.