Find/Replace with code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want my code to do what I manually do, but don't know how. I open up the
table [Names] and run a find/replace; I find this: ^b
and replace it with nothing. I search all the table, and any part of the
fields. How do I do this programatically?
thanks,
ck
 
I want my code to do what I manually do, but don't know how. I open up the
table [Names] and run a find/replace; I find this: ^b
and replace it with nothing. I search all the table, and any part of the
fields. How do I do this programatically?
thanks,
ck
Click to expand...

run an update query. or are you replacing formatting?
 
Okay, I got an update query to work for replacing ^B.
However, I also need to replace (with nothing) the following:
the bracket sign < and then any text that would be here and then the
bracket >
So in other words, I want to find and delete all instances of the brackets <
with what ever text is between them.
Click to expand...
I don't think you can put all that in a query, can you?
thanks,
ck


[email protected] said:
I want my code to do what I manually do, but don't know how. I open up the
table [Names] and run a find/replace; I find this: ^b
and replace it with nothing. I search all the table, and any part of the
fields. How do I do this programatically?
thanks,
ck
Click to expand...

run an update query. or are you replacing formatting?
Click to expand...
 
If there is only one set of brackets then you could use the following.

UPDATE YourTable
SET YourField = Left(YourField,Instr(1,YourField,"<")-1) &
Mid(YourField,Instr(1,YourField,">")+1)
WHERE YourField Like "*<*>*"

That would error if you had a field that Started with "<". You could change
the criteria to
WHERE YOURField Like "?*<*>*"
Or you could edit the expression to check the first character and if it was
"<" then don't subtract 1 to get the starting point.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Charlie said:
Okay, I got an update query to work for replacing ^B.
However, I also need to replace (with nothing) the following:
the bracket sign < and then any text that would be here and then the
bracket >
So in other words, I want to find and delete all instances of the brackets
<
with what ever text is between them.
Click to expand...
I don't think you can put all that in a query, can you?
thanks,
ck


[email protected] said:
I want my code to do what I manually do, but don't know how. I open up
the
table [Names] and run a find/replace; I find this: ^b
and replace it with nothing. I search all the table, and any part of
the
fields. How do I do this programatically?
thanks,
ck
Click to expand...

run an update query. or are you replacing formatting?
Click to expand...
Click to expand...
 
Back
Top