Replaces all matching items in a pipebar delimited list (|).
ListReplaceItem[List],[Old Item],[New Item],[Ignore Case])
Where:
List is the list to replace an item in.
Old Item is the item value to replace in the list.
New Item is the new item that is to replace all matching old items.
Ignore Case is set TRUE to perform a case insensitive replacement of the matching items in the list.
| Rule | Result |
|---|---|
| ListReplaceItem("A|B|C|D|E|F","c","X",TRUE) | This will return "A|B|X|D|E|F" |
| ListReplaceItem("A|B|C|D|E|F","c","X",FALSE) | This will return "A|B|C|D|E|F" |