Access - Dashes in a number (dhl)

[David]

(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

[fredg]

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.

[Allen Browne]

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.

[Hank Reed]

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

[Michael \(michka\) Kaplan [MS]]

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