Find and wipeout

  • 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 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
 
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
Click to expand...

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