Split up a single text field containing special characters

[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!

 

[Guest]

You used the name of the function 2 times in your post

It is the Split Function. You can find details on it in VBA help.
Basically, it creates an array of values separating them based on the
delemiter argument, so if you have strStuff = "Abc;#Def;#Ghi"

aryUnStuff = Split(strStuff, ";#")
Now you have an array of
aryUnStuff(0) will be Abc
aryUnStuff(1) will be Def
aryUnSturr(2) will be Ghi

Now in this case, if the original string starts or ends with ;# you will get
an additional element in your array the evaluates to a zero length string.