473,383 Members | 1,748 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

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;#

I can't really decide what the best method would be to format the fields with these problems and I'm just looking for some advice.
Nov 16 '06 #1
5 3003
bump............
Nov 16 '06 #2
MMcCarthy
14,534 Expert Mod 8TB
You say the tables are linked. Are these delimiters showing up in the linked file or somewhere else.



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;#

I can't really decide what the best method would be to format the fields with these problems and I'm just looking for some advice.
Nov 16 '06 #3
NeoPa
32,556 Expert Mod 16PB
I think your best bet is to look at the connection you're using.
Who provides the DSN for the link?
I think you need to go back to them and explain your problem as I think they've goofed a bit here.
Nov 17 '06 #4
PEB
1,418 Expert 1GB
However if you want to remove them you can use an update query
and the function replace([myfield],"#","") And replace([myfield],";","")
Nov 18 '06 #5
NeoPa
32,556 Expert Mod 16PB
Obviously, if your DSN is faulty, then you need to treat any updates of the data through that link with extreme caution!
You could (probably would) corrupt the data so that it wouldn't work correctly with your back-end app.

Only you will be able to check if this is a problem. If it is not then this could work for you.
Nov 18 '06 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

163
by: Shiperton Henethe | last post by:
Hi Know any good utilities to help me strip out the tags that Microsoft Excel 2002 leaved behind when you try and export an HTML format file? This is driving me NUTS. And really makes me...
4
by: Mark J. McGinty | last post by:
Greets, Part of the content of one of our web pages uses wingdings and Chr(239) through Chr(242) (which are little arrow outlines, though that's not really important.) It worked just fine in...
2
by: davegb | last post by:
I installed the sample CD from Viescas book, "Running MS Access 2000". Somehow, in the process of installing the files, it also installed a bunch of tables with weird names like MSysACEs,...
4
by: Deniz Bahar | last post by:
Hello, A couple days ago my friend (OOP guy) shows me what OOP was all about in C++. This morning I figured I can do pretty much the same thing with C (by putting function pointers in...
11
by: Ron L | last post by:
I have a barcode scanner which uses a "keyboard wedge" program so that the data it scans comes through as if it was typed on a keyboard. I am trying to have the data in the barcode be displayed in...
80
by: Andrew R | last post by:
Hi I'm creating a series of forms, each with with around 15-20 text boxes. The text boxes will show data from tables, but are unbound to make them more flexible. I want the form to be used...
4
by: pek | last post by:
I created a file name image.php which contains only the following code: <?php function createThumbnail($picture,$thumb,$new_w,$new_h) { $extension=substr($picture,strrpos($picture,".")+1);...
17
by: Chad | last post by:
I'm want static char *output; to hold the modified string "tel chad" However, when I debug it, static char *output holds the ascii value of the strng, and not the string itself. Here is...
26
by: Brad | last post by:
I'm writing a function to remove certain characters from strings. For example, I often get strings with commas... they look like this: "12,384" I'd like to take that string, remove the comma...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.