0

I have a people picker field that is supposed to pull the current user of the infopath form's name and so far it works fine, but when exported to excel it also pulls in some extraneous characters that I don't want my users to see.

Is there a way to hide them? I am unable to set the default value of the field so I can't use the translate function and I am unable to write custom code in the form itself so any way aside from those would be helpful.

Here is an example of what I get on export: Doe, John***;#94***

The characters in the italics are the ones I need removed.

Improve this question

1 Answer 1

Reset to default
0

I don't think you can fix this issue in SharePoint side. The best option is to create some script in Excel to remove this.

https://stackoverflow.com/questions/5023686/cleaning-people-group-data-exported-from-sharepoint-2010-lists

Improve this answer
2
  • Hi @AmalHashim, that is fine but how do I have the script run automatically whenever users want to export the list to excel? Is that possible?
    – Sadie
    Commented May 12, 2015 at 0:10
  • I believe you need to work out with your IT department and push this script every workstation.. inside the script first you should identify if data is coming from SharePoint export.. then identify people/lookup columns and clean it up. I don't see any other options for automating this.
    – Amal Hashim
    Commented May 12, 2015 at 0:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.