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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating bolded text exclusively. 0
importing data 0
French characters do not import 1
Differences Between Two Spreadsheets ? 2
is there an "end" character at the end of a .body command in VBA? 5
Removing double quotes from field names 0
insert memo feild into a memo field truncates at 255 characters - 4
Export from xlsx to csv preserving non-german characters 0

Top