I am running simple query on a linked sharepoint list. The field I am querying is a sharepoint choice field. The query returns the choices slected with special characters in front of it. How can I remove these characters?
Example: ;#Project Tracker Entry Created;#
I'm attempting to set a criteria where it returns records that is not equal to "Project Tracker Entry Created", however i belive these special characters are messing with the criteria.
Example: ;#Project Tracker Entry Created;#
I'm attempting to set a criteria where it returns records that is not equal to "Project Tracker Entry Created", however i belive these special characters are messing with the criteria.
