AnsweredAssumed Answered

Issues Excluding Values from a List

Question asked by smchampagne on Jul 13, 2018
Latest reply on Jul 13, 2018 by smchampagne

I'm generating a list of unique items from a field with the UniqueValues custom Function.

theList = {1, 2, 3, 4, 5}

 

I am then able to iterate through that list and pull out a single value using the GetValue function.

uniqueValue = 1

 

I also have a need to display the remaining values elsewhere, so I'm trying to utilize the ExcludeValues custom function to generate:

remainingValues = {2, 3, 4, 5}

 

However, the function seems to be failing unless the list physcially contains the ascii ¶ character.  For example:

Note that $newList displays the proper value.

 

However, when...

$theList = "1

2

3

4

5

"

 

I can't figure out why the list presented with an actual carriage return differs from the physical appearance of the ascii ¶.  In my test examples above, I am not utilizing the previously mentioned UniqueValues function.  However, it generates a carriage return separated list & is behaving exactly like my second screenshot.

 

What am I missing?

Outcomes