Remove Misc characters from a string of numbers?

E

Ernie

You could try the "substitute" function to replace those
characters with null or with a common character.

SUBSTITUTE(text,old_text,new_text,instance_num)


check the F1-Help in access for details.
-----Original Message-----
I need to compare product codes from various souces.
Click to expand...
Some will use various characters to separate a string of
numbers e.g. 1234-5678 or 1234.5678 Both are the same
product. Can I run a query to remove the "-" or the "."?
The characters do not always fall in the same position in
the string.
 
D

Dirk Goldgar

Ernie said:
You could try the "substitute" function to replace those
characters with null or with a common character.

SUBSTITUTE(text,old_text,new_text,instance_num)


check the F1-Help in access for details.
Click to expand...

There is no Substitute function in Access VBA. Maybe you're thinking of
the Replace function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re: Formula to Remove Special Characters 5
Deleting characters after 3rd occurence of a string 4
Remove characters from end of string 3
Extracting info from a string 7
Remove the right most 3 characters from a string 10
pulling certain characters from a string of text 3
Remove Leading Numbers from Text String 14
chop off last 5 characters of a string 9

Top