removing commas and apostrophes using query

  • Thread starter Thread starter Kathy MacAthur
  • Start date Start date
K

Kathy MacAthur

Hi everyone - hope someone can help.

I need to send a comma delimited flat file from an MS Access query (shipping
info) which will be imported into a shipping system. The need the shipping
info without commas and apostrophes. I've have made basic queries in past
but very basic. Is there an easy way to delete or remove something from a
record strictly for export purposes? In other words I don't want to have to
to an update query.

Any suggestions or help would be greatly appreciated.

Thanks,

Kathy
 
Sure... create a SELECT query to produce the records that will be exported.
In that query, in place of the field that has the shipping info, put a
calculated field that uses the Replace function to remove commas and
apostrophes:

ModShipInfo: Replace(Replace([ShippingInfo], ",", "", 1, -1, 1), "'", "",
1, -1, 1)
 
Back
Top