Removing HTML tags

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I imported an Excel spreadsheet into a table. 
The table contains a note field. The text was imported with HTML tags as follows:
____________________________________________________________
10/17/16 EC follow up email from Kevin as follows......<br /> Ed, we look forward to your presentation.  Attending will for sure by Jay Wocelka – Director of Retail Sales, Cary Trost – Director or Wholesale Sales, and myself – Division Manager/ Consumer Marketing.   We may have additional attendees depending on schedules and availability.   We look forward to meeting you on  November 15th.  Have a great day. Kevin<br /><br />10/17/16 EC Email from Kevin 
____________________________________________________________
I set the field to allow HTML tags and that allowed the view of the report to look normal.However, when I edit the field the tags are as shown above. 
I fiddled with Excel and got the tags removed and the text formated like it should. I don't want to have to import all the tables that have notes if there is some way within QB to fix it.

The above note field should look like this:

10/17/16 EC follow up email from Kevin as follows...... Ed, we look forward to your presentation.  Attending will for sure by Jay Wocelka – Director of Retail Sales, Cary Trost – Director or Wholesale Sales, and myself – Division Manager/ Consumer Marketing.   We may have additional attendees depending on schedules and availability.   We look forward to meeting you on  November 15th.  Have a great day. Kevin
10/17/16 EC Email from Kevin 
Photo of ed cooper

ed cooper

  • 922 Points 500 badge 2x thumb
  • Frustrated

Posted 2 years ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 2,100 Points 2k badge 2x thumb
You may want to try and remove it at the excel level before importing. Might find some macro/vba scripts for excel to do this for you
https://www.codeproject.com/Articles/639/Removing-HTML-from-the-text-in-ASP
Photo of ed cooper

ed cooper

  • 922 Points 500 badge 2x thumb
Thanks Chuck. I'm going to remove them at the Excel level and re-import since there is no way to do it within QuickBase.