Find Jobs
Hire Freelancers

A Windows 7 and XP HTML parsing program

$30-100 USD

Completed
Posted over 12 years ago

$30-100 USD

Paid on delivery
See attachment for a properly formatted spec. The program may be written in any cost free language that will run under Windows 7. It may be written with a Windows front end or may run in a browser. If it is a compiled program, the source code must be included. Include in proposal the language/scheme for the program. INPUT FIELDS TO THE PROGRAM: Date - Format yyyymmdd Time - Format hh:mm Input file name INPUT DATA: Example records to parse into one record: [SmartGene and the Institute of Medical Microbiology, University of Zurich Expand Their Collaboration to Address the Sequence-Based Validation of Mass Spectrometry Platforms for Clinical Microbiology][1] Mon, 15 Aug 2011 05:00:00 GMT ZUG, Switzerland and ZURICH, Aug. 15, 2011 /PRNewswire/ -- SmartGene, a provider of innovative software services for the management and analysis of genetic data, and the Institute of Medical Microbiology ("IMM"), University of Zurich, Switzerland, today announced an expanded... DATA FIELDS TO PARSE AND CREATE: Create the following fields where data is available: DATE (key) - Date from program input TIME (key) - Time from program input RECNO (key) - Unique record number that increments From the tag: THREF - Contents of the [tag TTITLE - Contents of the]() [tag title= item TTEXT - Text for the]() [tag From the]() tag: DLDAY - Day DLDATE - Date DLTIME - Time DLTZONE - Time zone DLSOURCE - Source From the tag: COCONT - The full text content of the tag OUTPUT: Output file a CSV file Output SQL statements (that will load the above data variables into a MySQL database ## Deliverables See attachment for a properly formatted spec. An Windows 7 and XP HTML parsing program The program may be written in any cost free language that will run under Windows 7. It may be written with a Windows front end or may run in a browser. If it is a compiled program, the source code must be included. Include in proposal the language/scheme for the program. INPUT FIELDS TO THE PROGRAM: Date - Format yyyymmdd Time - Format hh:mm Input file name INPUT DATA: Example records to parse into one record: [SmartGene and the Institute of Medical Microbiology, University of Zurich Expand Their Collaboration to Address the Sequence-Based Validation of Mass Spectrometry Platforms for Clinical Microbiology][1] Mon, 15 Aug 2011 05:00:00 GMT ZUG, Switzerland and ZURICH, Aug. 15, 2011 /PRNewswire/ -- SmartGene, a provider of innovative software services for the management and analysis of genetic data, and the Institute of Medical Microbiology ("IMM"), University of Zurich, Switzerland, today announced an expanded... DATA FIELDS TO PARSE AND CREATE: Create the following fields where data is available: DATE (key) - Date from program input TIME (key) - Time from program input RECNO (key) - Unique record number that increments, starting at 1 and incrementing for each output record from the parsed input data file. From the tag: THREF - Contents of the [tag TTITLE - Contents of the]() [tag title= item TTEXT - Text for the]() [tag From the]() tag: DLDAY - Day DLDATE - Date DLTIME - Time DLTZONE - Time zone DLSOURCE - Source From the tag: COCONT - The full text content of the tag Input Data Notes: No exteranous HTML tags or their contents (, , , etc.) in the fields. No image tags. THREF and TTITLE will usually be the same, but might differ. OUTPUT: Output file a CSV file (suitable for reading into Microsoft Excel 2003 or later) with the name: news_[DATE inputted above]_[TIME inputted above].csv that contains the above variables. Output SQL statements (that will load the above data variables into a MySQL database with the name: news_[DATE inputted above]_[TIME inputted above].sql Output Data Notes: The CSV files must be delimited ("DATA","DATA") so that a stray comma in the data will not cause a problem with loading the data into Excel. DATE must input into the MySQL database as a date variable. DLDATE must input into the MySQL database as a date variable. DLTIME must input into the MySQL database as a time variable. RECNO must input into the MySQL database as a numeric variable. All other variables as text. RAW FILE EXAMPLE (See full file for other input data issues): [SmartGene and the Institute of Medical Microbiology, University of Zurich Expand Their Collaboration to Address the Sequence-Based Validation of Mass Spectrometry Platforms for Clinical Microbiology][1] Mon, 15 Aug 2011 05:00:00 GMT ZUG, Switzerland and ZURICH, Aug. 15, 2011 /PRNewswire/ -- SmartGene, a provider of innovative software services for the management and analysis of genetic data, and the Institute of Medical Microbiology ("IMM"), University of Zurich, Switzerland, today announced an expanded... [Mice replace chimps as lab rats][2] Mon, 15 Aug 2011 01:08:02 GMT|[The Sydney Morning Herald][3] Humanity seems on a collective guilt trip over the use of chimpanzees, writes Brian Vastag. [Pfizer probed on "potentially improper overseas payments"][4] Sun, 14 Aug 2011 23:00:00 GMT|PharmaTimes Pfizer probed on "potentially improper overseas payments" [European Medicines Agency and its international partners complete successful inspection pilots][5] Sun, 14 Aug 2011 22:00:00 GMT|[login to view URL]@[login to view URL] (Administrator) ![European Medicines Agency (EMA)][6]Two pilot programmes of collaboration on inspections between the European Medicines Agency (EMA) and its international partners in the United States and Australia have concluded successfully, according to two recently published reports. The two programmes focus on increasing international regulatory collaboration among the regulatory agencies so that drug quality and safety can be enhanced globally. The report on the joint good clinical practice (GCP) inspection pilot programme details the success of information-sharing and collaboration on inspections relating to clinical trials. Under the joint GCP inspection pilot, the EMA and the US Food and Drug Administration (FDA) exchanged more than 250 documents relating to 54 different medicines and, in conjunction with the GCP inspectors of the EU Member States, organised 13 collaborative inspections of clinical trials. Parsed Variables: THREF - [login to view URL] TTITLE - [login to view URL] TTEXT - SmartGene and the Institute of Medical Microbiology, University of Zurich Expand Their Collaboration to Address the Sequence-Based Validation of Mass Spectrometry Platforms for Clinical Microbiology DLDAY - Mon DLDATE - 15 Aug 2011 DLTIME - 05:00:00 DLTZONE - GMT DLSOURCE - COCONT - ZUG, Switzerland and ZURICH, Aug. 15, 2011 /PRNewswire/ -- SmartGene, a provider of innovative software services for the management and analysis of genetic data, and the Institute of Medical Microbiology ("IMM"), University of Zurich, Switzerland, today announced an expanded... THREF - [login to view URL] TTITLE - [login to view URL] TTEXT - Mice replace chimps as lab rats DLDAY - Mon DLDATE - 15 Aug 2011 DLTIME - 01:08:02 DLTZONE - GMT DLSOURCE - The Sydney Morning Herald COCONT - Humanity seems on a collective guilt trip over the use of chimpanzees, writes Brian Vastag. THREF - [login to view URL] TTITLE - [login to view URL] TTEXT - Pfizer probed on "potentially improper overseas payments DLDAY - Sun DLDATE - 14 Aug 2011 DLTIME - 23:00:00 DLTZONE - GMT DLSOURCE - PharmaTimes COCONT - Pfizer probed on "potentially improper overseas payments" THREF - [login to view URL] TTITLE - [login to view URL] TTEXT - Two pilot programmes of collaboration on inspections between the European Medicines Agency (EMA) and its international partners in the United States and Australia have concluded successfully, according to two recently published reports. The two programmes focus on increasing international regulatory collaboration among the regulatory agencies so that drug quality and safety can be enhanced globally. The report on the joint good clinical practice (GCP) inspection pilot programme details the success of information-sharing and collaboration on inspections relating to clinical trials. Under the joint GCP inspection pilot, the EMA and the US Food and Drug Administration (FDA) exchanged more than 250 documents relating to 54 different medicines and, in conjunction with the GCP inspectors of the EU Member States, organised 13 collaborative inspections of clinical trials. DLDAY - Sun DLDATE - 14 Aug 2011 DLTIME - 22:00:00 DLTZONE - GMT DLSOURCE - [Do not include the source if an email address is present in the field] COCONT - Two pilot programmes of collaboration on inspections between the European Medicines Agency (EMA) and its international partners in the United States and Australia have concluded successfully, according to two recently published reports. The two programmes focus on increasing international regulatory collaboration among the regulatory agencies so that drug quality and safety can be enhanced globally. The report on the joint good clinical practice (GCP) inspection pilot programme details the success of information-sharing and collaboration on inspections relating to clinical trials. Under the joint GCP inspection pilot, the EMA and the US Food and Drug Administration (FDA) exchanged more than 250 documents relating to 54 different medicines and, in conjunction with the GCP inspectors of the EU Member States, organised 13 collaborative inspections of clinical trials.
Project ID: 3521289

About the project

12 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$42.50 USD in 14 days
5.0 (97 reviews)
5.9
5.9
12 freelancers are bidding on average $82 USD for this job
User Avatar
See private message.
$127.50 USD in 14 days
4.9 (158 reviews)
6.3
6.3
User Avatar
See private message.
$50 USD in 14 days
5.0 (126 reviews)
6.1
6.1
User Avatar
See private message.
$42.50 USD in 14 days
5.0 (54 reviews)
5.6
5.6
User Avatar
See private message.
$51 USD in 14 days
5.0 (31 reviews)
5.4
5.4
User Avatar
See private message.
$51 USD in 14 days
5.0 (43 reviews)
4.9
4.9
User Avatar
See private message.
$68 USD in 14 days
5.0 (34 reviews)
4.0
4.0
User Avatar
See private message.
$51 USD in 14 days
5.0 (13 reviews)
3.6
3.6
User Avatar
See private message.
$323 USD in 14 days
5.0 (3 reviews)
3.5
3.5
User Avatar
See private message.
$68 USD in 14 days
5.0 (10 reviews)
3.4
3.4
User Avatar
See private message.
$42.50 USD in 14 days
5.0 (6 reviews)
3.3
3.3
User Avatar
See private message.
$68 USD in 14 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Germany
5.0
5
Member since Jan 19, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.