Remove Misc characters from a string of numbers?

  • Thread starter Thread starter Ernie
  • Start date Start date
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.
 
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.
 
Back
Top