Hey there,
I am trying to get the text value from a lookup field (this is looking up another SharePoint list) without the special characters in the value.
I used a calculated field to get the value from the Project Name field however I don't want the 1;# special characters in the value that I want to write to the SharePoint list.
Is there a way I can remove these values, preferably within the form, or within a workflow?
Below is the value I am dealing with.
Appreciate the assistance on this.