Deleting Parts of a Table Field

G

GOL

I have a table with fields listing cities and states for different companies.
The city and state are in separate fields.

Whoever created the list, put quotation marks such as this around the fields:

City State

"Memphis Tennessee"
"Baton Rouge Louisiana"
Orange California

I'm going to mail merge the fields, but don't want the quotation marks in
them. The quotation marks are not on all fields as shown above, but I would
like to create some update query or formula that took the quotes out if they
were in the field to have it as the Orange California example looks.

Any suggestions??
 
O

Ofer

You can use the replace function to remove all quotation marks from the fields

UPDATE TableName SET TableName.City = Replace([City],"""","")
 
G

GOL

Thank you

Ofer said:
You can use the replace function to remove all quotation marks from the fields

UPDATE TableName SET TableName.City = Replace([City],"""","")
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



GOL said:
I have a table with fields listing cities and states for different companies.
The city and state are in separate fields.

Whoever created the list, put quotation marks such as this around the fields:

City State

"Memphis Tennessee"
"Baton Rouge Louisiana"
Orange California

I'm going to mail merge the fields, but don't want the quotation marks in
them. The quotation marks are not on all fields as shown above, but I would
like to create some update query or formula that took the quotes out if they
were in the field to have it as the Orange California example looks.

Any suggestions??
Click to expand...
Click to expand...
 
Top