By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,009 Members | 1,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,009 IT Pros & Developers. It's quick & easy.

Access - Dashes in a number (dhl)

P: n/a
(dhl) Using Access 2K. I have a ISBN number that is 10 char long and
has dashes somewhere in the number. I need to remove the dashes and
just leave the numbers. Is there any way of doing this? Thank you
for your help. David
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On 16 Sep 2004 12:05:19 -0700, David wrote:
(dhl) Using Access 2K. I have a ISBN number that is 10 char long and
has dashes somewhere in the number. I need to remove the dashes and
just leave the numbers. Is there any way of doing this? Thank you
for your help. David


Use the replace() function
NewField:Replace([OldField],"-","")
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

P: n/a
Using Fred's suggestion in an Update query is definately the way to go, but
you may run into difficulty using Replace() in a query in Access 2000.

If you do, see:
http://support.microsoft.com/?id=225956

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"fredg" <fg******@example.invalid> wrote in message
news:27******************************@40tude.net.. .
On 16 Sep 2004 12:05:19 -0700, David wrote:
(dhl) Using Access 2K. I have a ISBN number that is 10 char long and
has dashes somewhere in the number. I need to remove the dashes and
just leave the numbers. Is there any way of doing this? Thank you
for your help. David


Use the replace() function
NewField:Replace([OldField],"-","")
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Nov 13 '05 #3

P: n/a
It's amazing. String manipulation must be a lost art. Even the most
well programmed sites do not allow dashes or spaces in your credit
card number because they don't know how to parse them out.
Maybe students should be required to learn it before being
awarded they're under grad.
Hank Reed
Nov 13 '05 #4

P: n/a
Computer Science students are. The problem is that Access and Excel tend to
attract people developing things who have neither CS training nor prior
desire to pick up techniques....
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Hank Reed" <ha********@aol.com> wrote in message
news:f4**************************@posting.google.c om...
It's amazing. String manipulation must be a lost art. Even the most
well programmed sites do not allow dashes or spaces in your credit
card number because they don't know how to parse them out.
Maybe students should be required to learn it before being
awarded they're under grad.
Hank Reed

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.