Finditem Fails to Detect Valid List Member
I've come across something strange and wanted to ask if anyone has any ideas what is going on or if this is a bug.
I am creating a List using a Saved View that contains a list of codes (text) to be added to a list.
The import action is set to use code only, and the source codes are imported into both Name and Code of the target list.
The weird part comes after the list has been created and I try to use Finditem() on the list code to return the list item. For all codes, this works (as shown below) except if the code contains a space before a pipe:
If the list code = LS
Finditem(list, code) = LS
If the list code = LS|
Finditem(list,code) = LS|
If the list code = LS |
(with a space between "LS" and "|")
Finditem(list,code) = BLANK
I've no idea why for some reason Finditem() does not work on the code with a space before the "|" but this appears to be the case.
Is this a bug related to special characters or am i missing something?