Remove some certain words, tags in fields

[shinichi_nguyen]

Hi everyone.
We use Access to pull data from data warehouse and this year they upgraded the new system on the back end and moved old data to the new one. Problem is that in some tables having big fields such as Asset Long Description, Work Long Description and when moved to the new database system, somehow there are certain some XML tags such as <br> </br, etc.. added into the description. So when we pull the data onto the table in Access, is there a way to remove those tags out of the descriptions fields? a macro or module?
Much appreciate your help.


Thank you

[orange]

Off the top of my head - you'll need to check each string in each description and compare it to your list of "tags/etc" to be removed.
General approach

For each record
     For each string
            If string = a string to remove Then get next String
            Else
                 Write the string
            End If
    Next String
Next Record

I suggest you investigate the Split function and examples of how to use it.
Here's one reference
http://msdn.microsoft.com/en-us/libr...ice.10%29.aspx