We help IT Professionals succeed at work.
Get Started

Some access backend field text contaminated with HTML tags

CompAlign asked
Last Modified: 2013-12-24

Situation: I am an experienced developer(new to ColdFusion ) currently working with a CF development team
(their first app) on a data integration project where two independent front end applications (one build in Access FE/BE linked tables, the other in Dreamweaver/Coldfusion) that will share common tables in the Access back end. The fully integrated setup has not been tested yet.

In preparation for the full integration test, the CF development team has been sending us copies of their beta test backend
with live user data. In one of the text fields, there were numerous records where the text is embedded with HTML tags.
This is not what we expected since we need the actual entry only.

For example, notice the "&nbsp" 's and <I's in these scientific review citation records:

   What's New in&nbsp;Arc Info 8

   Review of: James Stone, and Fred Underwood. <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">Field
   Observations Of <I style="mso-bidi-font-style: normal">Pennisetum clandestinum</I>, Kikuyugrass, In Texas</SPAN>.  
   Version Final. Hours spent: 4

Question: Is there a remedy for this? We want to have the Access text field contain the exact user entry only so that it can be
               shared with other application front ends without having to scrub the html tags out.

Note: The "contaminated text" records ares displaying OK in the CF front end browser. This is probably why the CF team didn't notice during Beta. Also, it only appears in about 300 of the 5000 citation records.

Thanks for your ideas. Will clarify as necessary.

Watch Question
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE