Need to remove unwanted characters from string

[sirnose1]

I have a column in a database with chemical Analytes. I need to remove the commas from these strings. For example:
I need to make C-1,2,3,4-TCDD look like C-1234-TCDD. There are 20 different constituents but I just want to remove the commas.

 

[CautionMP]

sirnose1,
[tt]Replace("C-1,2,3,4-TCDD",",","") = C-1234-TCDD[/tt]

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[djj55]

Just a note from a former analyte programmer.
Try using the CAS number. It's not full proof but more or less standard.

CautionMP's solution should do just fine.
djj

 

[sirnose1]

For some reason, These people wanted the "-" removed from the cas no., so I need do a find and replace for all the analytes, not just one, so I need a find and replace for the whole column. Mine doesenty seem to be woprking..

 

[djj55]

Your query in Access would look something like this:

UPDATE Categories SET Categories.CategoryName = Replace([CategoryName],"-","");

Hope this helps
djj

 

[sirnose1]

The query I used is this: "UPDATE tblMaster SET tblMaster.cas_no = Replace([cas_no],"-","");"
Doesent update the column.