Find and replace

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
Create a query, and in the Criteria row under the problem field, enter:
Like "*[""]*"
 
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

Allen Browne said:
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.


Chris said:
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
Click to expand...
Click to expand...
 
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.


Chris said:
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

Allen Browne said:
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.


Chris said:
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
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top