Access find and replace multiple values with a macro

[stephlal]

Hello guru's,
I'm importing data in access that have html tags and need to get rid of them. I can't think of any easy way of doing this but with a macro that would search for values and replace them with spaces by means of an automated solution. I know there's a find / replacement functions in vba, i'm just no expert in coding it. I also need to be able to execute this find replace on 3 specific columns in 1 table, and all columns in another table.
i.e.: find:=<div> replacement:=""
find </div> replace ""
find <*> replace "" (can I use a wildcards?)
Essentially I would have 10 to 20 find/replace lines.

Any help or direction on how to accomplish this would be great.

Thanks

 

[PHV]

Have a look here:

http://msdn.microsoft.com/library/en-us/script56/html/2380d458-3366-402b-996c-9363906a7353.asp

You'll have to add a reference to the Microsoft Scripting Regular Expressions library.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[stephlal]

Thanks for the info, I'll check it out!