Results 1 to 3 of 3
February 22nd, 2006, 07:35 PM #1
How do I source HTML as a field in Excel Spreadsheet
- Join Date
- February 22nd, 2006
This may be the stupidest newby question ever, but I am using an Excel spreadsheet as my input source and I have a field that is HTML formatted text. It contains <p>, <h3>, and the text itself has quotation marks and other characters that English text normally has in it. When I try to source in this data from the spreadsheet I just get "<p> as the input. (The actual text field in Excel begins with <p> without the leading quote.) How do I source HTML source in a text field in a spreadsheet?
February 22nd, 2006, 09:51 PM #2
Hi Mark, and welcome to ABW !
No questions are stupid, in-fact your question sounds pretty good to me. My first suggestion is something you may have already tried. Tick the "Text values are in quotes" check-box found on the "Sources" tab in WebMerge. If it has been checked, then un-check it.
The next thing I would try is to use the "Raw" option in your template tags, where you need the text rendered just like it is in the spreadsheet.
Take a shot at it, and let us know how (if) it works.
March 29th, 2006, 05:04 AM #3
- Join Date
- March 28th, 2006
(Deleted) Sorry, wrong thread
By Celicaphile in forum Programming / Datafeeds / ToolsReplies: 8Last Post: April 11th, 2006, 04:01 PM
By bsnrjones in forum WebMerge (Fourthworld.com)Replies: 1Last Post: January 20th, 2004, 07:07 PM
By Lionstail in forum Programming / Datafeeds / ToolsReplies: 4Last Post: February 2nd, 2003, 09:57 PM