Jump to content

Need help with getting some code to pull info out of html files


vonneffdobermans

Recommended Posts

Hello everyone... I am new here.. But I am sure I will learn as I go...

 

Okay, What I am trying to do is this:

 

I have about 30,000 html files that I need to get the info out of, and to be put into a CSV file for Microsoft excel.

 

each file has a few lines of info in them, I need them all in seperate columns, so That I can use it in Microsoft excel.

 

Below is what is in most of the html files. Some do not have the info, so it needs to be able to move on if it does not have the info in it. I also put where I would want the info to be...

 

AQUARIUM PHARMACEUTICALS - P/C ALGAEFIX W/ FREE ECOFIX - (column A)

 

Royal ID: AAP169P - (column B)

 

UPC: 317163161692 - (column C)

 

Vendor: AQUARIUM PHARMACEUTICALS - (column D)

 

(everything below vender should all go into same cell, keeping the linebreaks, etc... the same.) in (column E)

 

AlgaeFix effectively controls the growth of many types of algae, including blanketweed. Will not harm live plants or koi and goldfish. EcoFix makes pond water clean and clear. Breaks down dead algae. Increases oxygen levels in pond water.

 

AlgaeFix effectively controls many types of green or green water algae, string or hair algae and blanketweed in ponds that contain live plants. Controls existing algae and helps resolve additional algae blooms. Keeps ornamental ponds and water gardens clean & clear. EcoFix helps create a healthy ecosystem for pond fish. By digesting sludge, and reducing organics, EcoFix increases oxygen levels and makes pond water clean and clear.

 

    * 16 fl oz PondCare® AlgaeFix® with free 8 fl oz PondCare® EcoFix

    * 169B Treats 4,800 US Gal (18,168 L) (147A Treats Up to 2,000 US Gal)

    * Restricted for sale in Canada, UK

 

Thats about it in a nutshell... I had someone help me before with this, and it worked great.. But somehow I lost the files, and how I had to get the server on my home computer to do this.

 

 

I would appreciate any help I could get on this.

 

Thanks in advance

 

Vonneffdobermans

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.