Find and wipeout

[Chris]

I'm trying to scan a field in one of my tables and find a specific character
and wipe it out. 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 wipe them out?

Thanks,
Chris Savedge

 

[John W. Vinson]

I'm trying to scan a field in one of my tables and find a specific character
and wipe it out. 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 wipe them out?

Thanks,
Chris Savedge

What do you mean by "wipe out"? Permanently erase them from the table?

If so, use an Update query updating the field to

Replace([fieldname], """", "")

The trick is that in order to pass a doublequote character in a doublequote
delimited string you must use two consecutive doublequotes - so four in a row
"""" corresponds to just one " character as an argument.

 

[Jerry Whittle]

http://support.microsoft.com/kb/109825

 

[De Jager]

I'm trying to scan a field in one of my tables and find a specific
character
and wipe it out. 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 wipe them out?

Thanks,
Chris Savedge