Returns a pipebar (|) delimited string based on filtering an existing Pipebar (|) delimited string
SppStringFilter([String To Filter],[Filter Text],[Show Duplicates])
Where:
String To Filter is a Pipebar (|) delimited string.
Filter Text is the text that will be searched for when filtering.
(Optional) TRUE to show duplicates, FALSE (default) to ignore.
| Rule | Result | Meaning |
|---|---|---|
| SppStringFilter("A|B|C|B|A","A",TRUE) | A|A | Will return a pipebar delimited string containing the filtered results. |