Greetings,
Im new to working directily with XML but im a SharePoint admin by trade so im familliar with it to some extent. Here is the crux of my problem.
Im building a table calling fields from a SharePoint list. One of my fields is a person selection field with multiple values. When I create my data view and copy my XSL into my webpart the field in question returns these results
What im trying to do is strip out the #12#. I thought a translate function would work but I have had no success. I have also tried a substring after but have had no luck with that either.
I would appreciate it if someone could point me in the correct direction.
Thanks
Anything worth doing is worth messing up at least 5 times before you get it right!
Im new to working directily with XML but im a SharePoint admin by trade so im familliar with it to some extent. Here is the crux of my problem.
Im building a table calling fields from a SharePoint list. One of my fields is a person selection field with multiple values. When I create my data view and copy my XSL into my webpart the field in question returns these results
Code:
User1;#12;#User2
What im trying to do is strip out the #12#. I thought a translate function would work but I have had no success. I have also tried a substring after but have had no luck with that either.
I would appreciate it if someone could point me in the correct direction.
Thanks
Anything worth doing is worth messing up at least 5 times before you get it right!