Find and replace

[Chris]

I'm trying to scan a field in one of my tables and find a specific character
and remove it. However, the character is a " so I'm having difficulty. The
field I speak of of contains the sizes of our material so the values look
like this:

1/4"
1/2"
1/3" and so on.

How can I find all of the " in my feild and remove them? I don't want to
replace them I just want to remove them.

Thanks,
Chris Savedge

 

[Allen Browne]

Create a query, and in the Criteria row under the problem field, enter:
Like "*[""]*"

 

[Chris]

Allen,

This allows me to find them. What I want to do is actually remove the "
character from each value where it is present. How do I strip off this
character?

Thanks,
Chris

Create a query, and in the Criteria row under the problem field, enter:
Like "*[""]*"

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I'm trying to scan a field in one of my tables and find a specific
character and remove it. However, the character is a " so I'm having
difficulty. The field I speak of of contains the sizes of our material
so the values look like this:

1/4"
1/2"
1/3" and so on.

How can I find all of the " in my feild and remove them? I don't want to
replace them I just want to remove them.

Thanks,
Chris Savedge

 

[KARL DEWEY]

Use an update query after backing up the database.
The double quote character is ASCII 34 so use this as the 'Update To' --
Replace([YourField], Chr(34), "")

--
Build a little, test a little.

Allen,

This allows me to find them. What I want to do is actually remove the "
character from each value where it is present. How do I strip off this
character?

Thanks,
Chris

Create a query, and in the Criteria row under the problem field, enter:
Like "*[""]*"

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I'm trying to scan a field in one of my tables and find a specific
character and remove it. However, the character is a " so I'm having
difficulty. The field I speak of of contains the sizes of our material
so the values look like this:

1/4"
1/2"
1/3" and so on.

How can I find all of the " in my feild and remove them? I don't want to
replace them I just want to remove them.

Thanks,
Chris Savedge

.