Closed

ASP Parse Data in SQL Statement

This project was awarded to hsedidin for $28.9 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $100 USD
Total Bids
8
Project Description

ASP code to parse and redraw monthly schedules
[url removed, login to view]
Input :

#104 [OFF=16 #1] [CRD= [url removed, login to view] #3] [BLK=[url removed, login to view]] [TAFB=[url removed, login to view]] [CO= [url removed, login to view]] [wknd=0 cod=0]

31| 1 2| 3 4 5 6 7| 8 9| 10 11 12 13 14| 15 16| 17 18 19 20 21| 22 23| 24 25 26 27 28| 1 2|
FR| SA SU| MO TU WE TH FR| SA SU| MO TU WE TH FR| SA SU| MO TU WE TH FR| SA SU| MO TU WE TH FR| SA SU| M
| | 302 | | 301 | | 302 | | 301 | |
X | : : | X TLHTPAMKEATL| : : | X TLHTPAATL X | : : | X TLHTPAMKEATL| : : | X TLHTPAATL X | : |

302= 2100 1035/2022;301= 2120 0725/1720; T
Parse output per record :
schedule number (#104)
Days off [OFF]
Credit [CRD]
Block [BLK]
Time away from Base [TAFB]
Carryover [OFF]
*Then from the schedule section
First Day (Example:21)
First Day of week (Example:FR)

parse and create a schedule field in the form (schedule number,day 1,day2,etc..). All (:) replaced with (X)'s.

105, X , X , X , X , X , 301TLH , TPA , ATL , 303 - , ATL , etc...

for each record a sqlText variable will be created to insert the data into a database. NOTE: I do not need any of the database code, only the formated sql Statement.
Example :

INSERT INTO lines (Line,Schedule,Daysoff,TAFB,Carryover,Block,Credit,FIRSTDAY,FIRSTDAYOFWEEK) VALUES (' 205 ',' 205 , X , X , X ,L3126CAE , CHS , GSO , LGA , X , X , X ,L3129CHS , CHS , CHS , LGA , X , X , X ,L3126CAE , CHS , GSO , LGA , X , X , X ,L3126CAE , CHS , GSO , LGA , X , X ','14,','[url removed, login to view]','[url removed, login to view]','[url removed, login to view]','[url removed, login to view]','31','MO');

The asp page will be able to parse multiple schedules supplied by a text file.
The second page is a [url removed, login to view] page.
It should taked the parsed data fields and generate an output that is identicial (expcept for data that was not parsed) to the originial. Sample data is fine.



## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Complete ownership and distribution copyrights to all work purchased.





## Platform

No JavaScript

Pure ASP

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online