Deleting double quotes out of my table?

[kawi6rr]

I searched and haven't found anything that shows how to do this.

I had a previous import process that brought int he double quotes from the txt file. I am now trying to clean up the table to get rid of all the doulbe quotes surrounding the "image type" in the imageType field.

ImageType
"CT ABD AND PELVIS, 3 PHASE_"
"CT ABD AND PELVIS, 3 PHASE_"
"CT ABD AND PELVIS, 3 PHASE_"
"CT ABD AND PELVIS, 3 PHASE_"
"CT ABD AND PELVIS, 3 PHASE_"
"CT ABD AND PELVIS, 3 PHASE_"
"CT ABD AND PELVIS, 3 PHASE_"
"CT ABD AND PELVIS, 3 PHASE_"
"CT ABD AND PELVIS, 3 PHASE_"

I've tried these two queries but they dont get rid of the double quotes.

1) UPDATE DI_Image SET DI_Image.ImageType = ""
WHERE (((DI_Image.ImageType) Like "*" & Chr(34) & "*"));



2) Replace("Chr(34)", "", "")

Any help is apprecaited, thanks.

[JoeM]

If you open the table, highlight the column, and go to "Find and Replace", you can replace the double-quotes with nothing for the whole column at once.
Just be sure to use the setting "Any part of field" under "Match:".

[Siiig]

I actually would up being lead to the Replace function for your question. If you take the "Chr(34)" out of quotes...

Replace([ImageType],Chr(34),"")

Putting that in quotes means the formula will literally be looking for "Chr(34)" rather than a double quote.

Try it and let me know.

[kawi6rr]

Thanks for both responses, I used the find and replace method because it was much easier.