Results 1 to 3 of 3
February 23rd, 2006, 11:54 PM #1
Excel tab-delimited export confuses WebMerge
- Join Date
- February 23rd, 2006
The problem I'm experiencing is that fields in Excel containing commas are being wrapped in quotes by the Excel tab-delimited export.
Excel text entered:
Excel tab-delimited export:
...which then causes problems with the html code
WebMerge gets confused on the quotes that appear in this situation.
Comma-delimited export is not an option since my file contains commas I've tried the raw option, but it does not help because WebMerge is getting hung up on the input file before it ever goes to the output file containing the tag with the raw option.
I'm sure I'm not the first person to experience this. Is there a work around or has anyone figured this out already?
My enormous thanks in advance. I'm really looking forward to being able to enjoy the time-saving benefits of this tool!
February 24th, 2006, 09:22 PM #2
- Join Date
- January 17th, 2005
I am not sure I understood you fully, but I get the same result when exporting to tab-delimited. I use TextPad with a RegEx search replace to remove instances of ["][end of line], [tab]["] and ["][tab] before running WebMerge.
March 4th, 2006, 12:18 PM #3
Originally Posted by cscull
- Join Date
- January 18th, 2005
- Los Angeles, California
That said, there's always one more format out there, and little consistency among different vendors in how they format their output, so we can't rule out the possibility that you've discovered a format WebMerge can't handle.
Please send me a compressed copy of a >2MB portion of your source file, and note where it came from (which application, what settings used for export). I'll see what I can do to make WebMerge able to handle that too if it doesn't already.Richard Gaskin
Developer of WebMerge: Publish any data feed on any site
By Castell Ddu in forum WebMerge (Fourthworld.com)Replies: 4Last Post: March 25th, 2006, 01:30 PM
By Doug247 in forum Midnight Cafe'Replies: 5Last Post: December 12th, 2005, 03:52 PM
By westgroup in forum Programming / Datafeeds / ToolsReplies: 13Last Post: June 9th, 2005, 01:10 AM
By bbb in forum Programming / Datafeeds / ToolsReplies: 10Last Post: August 30th, 2004, 05:03 AM
By hershey in forum Programming / Datafeeds / ToolsReplies: 2Last Post: July 17th, 2002, 07:52 AM