Data Parsing
$30-50 USD
Paid on delivery
Require Access VB code to extract data from fixed format report into records with date/time stamp from report on each record added. Routine should run from form and have flexible filename but keep structure from report. Example attached for report. Expected table/record structure Field names: UCDGRP,KEY,UCDOFFR,UCDANSR,UCDDFLCT,UCDABNDN, UCDNS,UCDPRMPT,UCDBLOCK,UCDUSAGE,DATE,STARTTIME,STOPTIME (date, start/stop time from summary header located on 3rd line in each group) Data parsed from first & second groups from example report should extract following values: 0,VMAIL,111,108,0,2,0,0,0,42,2003/05/06,15:00,15:30 1,EPBTHLP1,4,4,0,0,0,0,0,4,2003/05/06,15:00,15:30 2,EPBTSALES,0,0,0,0,0,0,0,0,2003/05/06,15:00,15:30 3,EPBTCUSTMGT,0,0,0,0,0,0,0,0,2003/05/06,15:00,15:30 0,VMAIL,115,109,0,6,0,0,0,45,2003/05/06,15:30,16:00 1,EPBTHLP1,1,1,0,0,0,0,0,1,2003/05/06,15:30,16:00 2,EPBTSALES,0,0,0,0,0,0,0,0,2003/05/06,15:30,16:00 3,EPBTCUSTMGT,0,0,0,0,0,0,0,0,2003/05/06,15:30,16:00 Data should be populated to access table not csv like displayed above.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
MS Windows and Access XP
Project ID: #2937725