I am designing a workflow that successfully pulls in a text field "Primary Service" but seems to also include what I presume to be the Term Store ID of the value. (The list uses the term store for that field.) Common among all results is the presence of a pipe ( | ) followed by information I don't need.
Because Primary Service will be variable in length, I cannot seem to use the fn-remove(). If there was a way to count the characters beforehand I suppose I could make this work but I can't find a facility to help with this.
1. What would be the best approach to address this problem? (I found similar examples but none specific to this one.)
2. If the remove() function is still a possibility (or other function), is there a "and follow" character that would allow me to delete everything to the right of and including the pipe?
This is my first foray into using inline functions so detail is welcome.