Results 1 to 11 of 11
  1. #1
    Full Member
    Join Date
    January 18th, 2005
    Posts
    276
    I want to use the .csv file I got from Overstock; but, the description is just packed with html coding. The field is too large for Excel to deal with and when I tried to remove in Access - the entire database became corrupted. Database too large?

    Does anyone know a simple means of removing unwanted html coding from a .csv field?

    Very much appreciated.

    John

  2. #2
    ABW Ambassador Nature Boy's Avatar
    Join Date
    January 18th, 2005
    Location
    Tennessee
    Posts
    1,423
    Did you try opening it in notepad and doing a search/replace?

    That's what I use when I've got a lot of clutter in some fields and excel won't do the job.
    Scott
    If you can't dazzle them with brilliance, then baffle them with bulls#!t
    Don't tell me that you'll do it... SHOW ME.
    Just because everyone else is drinking it is no reason for me to drink the KOOL-AID.

  3. #3
    Full Member
    Join Date
    January 18th, 2005
    Posts
    276
    Hi Nature Boy!

    Yeah, notepad won't take the whole column of the feed - it's some 24,000 items each with a terrible description field.

    I'm thinking of just using the images and "short description" with a link to the merchant product page.

    It's probably not worth the hassle anyway. But, thanks for the suggestion.

    John

  4. #4
    Newbie
    Join Date
    January 18th, 2005
    Posts
    47
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by guam:
    I want to use the .csv file I got from Overstock; but, the description is just packed with html coding. The field is too large for Excel to deal with and when I tried to remove in Access - the entire database became corrupted. Database too large?
    John <HR></BLOCKQUOTE>

    If you know a bit PHP, there's a function strip_tags. removes all html tags.
    regular expression is the keyword
    <a href="http://www.freemobilefun.net">Free cell phone wallpapers</a>
    <a href="http://www.allmyringtones.com">Cell phone ringtones</a>

  5. #5
    ABW Ambassador buy_online's Avatar
    Join Date
    January 18th, 2005
    Location
    Richmond, VA
    Posts
    3,234
    Since you don't need to do anything sophisticated, simply get a better text editor like TextPad. Notepad is not meant for heavy duty jobs.

    Do a search and replace, should be quite easy.

    Fred

  6. #6
    Full Member brianboru's Avatar
    Join Date
    January 18th, 2005
    Posts
    350
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by buy_online:
    Since you don't need to do anything sophisticated, simply get a better text editor like TextPad. Notepad is not meant for heavy duty jobs.

    Do a search and replace, should be quite easy.

    Fred <HR></BLOCKQUOTE>

    I agree Textpad is excellent for that kind of work. Plus you can use it for a month for free before you buy it. There is actually a built in MACRO function which will strip ALL html code automatically.

  7. #7
    Newbie
    Join Date
    January 18th, 2005
    Posts
    4
    Get EditPad Lite.
    http://www.editpadpro.com/editpadlite.html

    It's fast.

    Mohd Fairuz

  8. #8
    Newbie
    Join Date
    January 18th, 2005
    Posts
    39
    Maybe you should take a peak at the AMWSO forum, the affmgr has a nice tool to do just that, rip html.. (Free Data Cleaner Tool)

    cheers!

    edit: Textpad rocks btw!

  9. #9
    Newbie
    Join Date
    August 2nd, 2006
    Posts
    6
    Ahh - use TextPipe with a 'Remove HTML' filter inside a CSV field restriction.

  10. #10
    ABW Ambassador kse's Avatar
    Join Date
    November 29th, 2005
    Posts
    2,511
    I have been using notepad as well for this, it is slow but it works great.

  11. #11
    ABW Ambassador kse's Avatar
    Join Date
    November 29th, 2005
    Posts
    2,511
    I just wants to say that I have started to use two of the tools that where talked about in the above post, they were "Free Data Cleaner Tool" & "EditPad Lite" They are both great. I can now convert (edit) a 10MB feed in less then 1 min. where before it took over 6 hours in Notepad, !!!!! So Good Buy Notepad....
    Thank you all for your helpful post.
    kse........

  12. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Featured: TIP: Viewing large datafeed files
    By isellstuff in forum Programming / Datafeeds / Tools
    Replies: 11
    Last Post: July 6th, 2011, 09:52 AM
  2. Dealing with large datafeed files in PHP
    By MoreBeer in forum Programming / Datafeeds / Tools
    Replies: 4
    Last Post: April 6th, 2010, 07:03 PM
  3. AllPosters.pl - Database Files using Telnet
    By anwaar ul haq in forum Cusimano.com Scripts
    Replies: 7
    Last Post: April 21st, 2005, 03:51 PM
  4. Removing Quotes from Data in a MySQL Database
    By Taurus in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: January 1st, 2003, 03:36 PM

Posting Permissions

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