J
Jose
Using Access, I am connecting to set of sharepoint survey results -
using "get external data"
Two of the questions allow for multiple selections. Sharepoint groups
all the selections for a single question into a single table cell (text
field). Each selection in the text field is seperated by a ;#
How can i split up this single text field (with multiple selections)
using the special characters: ;#
I'm not sure if its a SQL statement or a query function?
Any help would be GREATLY appreciated!!
Thanks!
using "get external data"
Two of the questions allow for multiple selections. Sharepoint groups
all the selections for a single question into a single table cell (text
field). Each selection in the text field is seperated by a ;#
How can i split up this single text field (with multiple selections)
using the special characters: ;#
I'm not sure if its a SQL statement or a query function?
Any help would be GREATLY appreciated!!
Thanks!