title: stripping ,(commas) from text in msaccess query
body: <p>Can someone please advise how i can create an expression for use in a msaccess query, that strips out , and . characters and replaces them with a space</p>
  
  <p>for example i have a data field containing customer names (eg Mickey Mouse Company, Ltd.)</p>
  
  <p>i need to extract this from the database using a query, and export it to csv file, but as you can imagine the , in the customer name creates problems in the csv file</p>
  
  <p>will it possible to creat an expression to strip these punctuation marks out and replace them with a space so that the subsequent csv file doesnt get messed up</p>
  
  <p>many thanks in anticipation</p>