Fragensteller
Remove spurious characters from share points column values and count items

-
Hello,
I have data from a MS Forms (a multiple choice answer) that feeds data to a SharePoint list; the data looks like ["Item1", "Item2", "etc"], is there a way to delete square brackets and quotes so that I can then count the numbers of "item 1" and "item 2" present in each column?
I am currently doing this process through Excel (export data, manipulate and return to SP), would it be possible to do everything within SharePoint?
Thanks for the help.
- Bearbeitet Miche -e Donnerstag, 12. Juli 2018 11:49 removed formatting errors
Frage
Alle Antworten
-
Hi Miche,
How did you set the multiple choice answer?
If I create a multiple choice column, the value is like:
Please provide your steps to reproduce this issue.
Thanks,
Wendy
Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams. -
Hello Wendy,
The data in the columns look like the figure below. They are responses collected from a multiple choice MS Forms responses. There can be multiple choice for one questions, which are comma separated. Each option is included in quotes and the all the chosen options are bound with square brackets.
Thanks for your help.