I'm using the FireFox extension, and I'm hoping that it will be all of what I need.
I wasn't sure how to categorize this, so it remains uncategorized for now.
I am interested in scraping a site, and I require a CSV file in order to use the scraped data for importation to a website. We all know that a CSV file is comma delimited, and if there are commas in the text even if the text has has double quotes around it, my spreadsheet delimits the value and it continues in the next column of the spreadsheet. A manual cleanup defeats the whole purpose.
I ran into the same problem when in the middle of the description text there is a double quote [ " ] to mean inches. As you can imagine, in a product description if someone states [24" Monitor], it's not good.
I guess what I could use is some help figuring out how to replace internal commas and quotes with something else, perhaps a slash instead of a comma and the value [ in. ] instead of the double quote. Preferably, before it gets to the spreadsheet that actually does the CSV to spreadsheet conversion.
Any ideas? I did search all over for a regex to handle it for me, but learning regex from scratch is going to take be painful.