User Profile
Collapse
-
bump........... . -
Trying to remove extra characters from access tables
We're currently using Sharepoint to pull data into Access, so our tables are linked. In our tables in Access we are getting extra characters (;#) in our data that needs to be removed. I'm assuming that the extra characters are coming from the information in Sharepoint as the field is a checkbox field with multiple selections possible.
The way it looks:
Sharepoint -> Name; Name2; Name 3
Access -> ;#Name;#Name2;# Name3;#...
No activity results to display
Show More
Leave a comment: