Removing the character " from a field

M

Margaret

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
 
J

Joe Fallon

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.
 
Top