Removing the character " from a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
Can someone please advise me the string to use when wanting to remove " (Inverted commas / conversation marks) characters from a field. The field has no text and is being imported directly from csv to Access and cleaned along the way.

Would appreciate any help.

Regards
Margaret
 
One way is to use the Replace function in a query and choose not to replace
" with anything.
--
Joe Fallon
Access MVP



Margaret said:
Hello
Can someone please advise me the string to use when wanting to remove "
Click to expand...
(Inverted commas / conversation marks) characters from a field. The field
has no text and is being imported directly from csv to Access and cleaned
along the way.
 
Back
Top