Results 1 to 4 of 4
  1. #1
    Full Member
    Join Date
    January 17th, 2005
    I am having problems with some of my feeds. When I view them in Excel as a tab delimited file they look fine. But then when I save them in tab delimited some of the fields are getting " (quotes) placed around the text. Then when I import them into sql they are printing with text.

    Is there some way in Excel to strip these out? The problem is that I cannot see them in Excel, but they are in the text file.

    I would think there is someway to tell Excel not to add these, but I sure can't figure it out.


    Goal: $10,000/month by 12/04

  2. #2
    ABW Ambassador Mike O's Avatar
    Join Date
    January 17th, 2005
    Los Angeles area
    I had the same problem.

    It turns out it's a known bug with Excel. Any text field that has a comma in it has surrounding quotes added when it's saved as a tab-delimited file.

    I assume Excel thinks it's saving text as comma-delimited, and so adds the quotes.

    Test this yourself, add a comma to a text field, save it, and check. Incredible! It's been known for awhile, and good old MS hasn't seemed interested in fixing it, either.

    My only use for Excel right now is in preparing text files for use by WebMerge. WebMerge has a checkbox ("Text values are in quotes") that can be checked to strip off the unwanted quotes, so I can live with it.

    But hey Microsoft, fix it already!

    -- Mike

    "Men travel faster now, but I do not know if they go to better things."
    -- Willa Cather

  3. #3
    Full Member
    Join Date
    January 17th, 2005
    Your right! That is the problem. Now I guess I will have to open them in a text file and do a search and replace for the "'s. I do the same as you when using WM and it works great. I suppose that there is some way in my script to strip them, but that is over my head right now.

    Thanks for the quick answer!


    Goal: $10,000/month by 12/04

  4. #4
    ABW Ambassador buy_online's Avatar
    Join Date
    January 18th, 2005
    Richmond, VA
    MikeO is right, thank you Micr*s*ft !

    I hate to say it, but be careful with the text editor, there are some HTML tags that have double quotes in them.

    What you can do, is do a column-by-column search and replace (click on the "find" tab in the search window to find the first instance). You should select the entire column to limit your search. This way you should be able avoid changing the HTML source.

    THere are some other ways to strip the double-quotes out of the feed using for example PHP, but that's another story.

    I am looking for add-ins to excel that can help with this and other things, I'll let you guys know if I find anything.


    You might just be a Redneck if - Birds are attracted to your beard...

  5. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Excel expert?
    By SSanf in forum Midnight Cafe'
    Replies: 2
    Last Post: July 25th, 2005, 11:27 AM
  2. Need Help with Excel
    By Rhea in forum Programming / Datafeeds / Tools
    Replies: 8
    Last Post: June 1st, 2005, 03:32 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts