ASP code to parse and redraw monthly schedules
#104 [OFF=16 #1] [CRD= 81.16 #3] [BLK=80.30] [TAFB=279.24] [CO= 0.00] [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]
Time away from Base [TAFB]
*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.
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,','289.48','0.00','77.35','77.35','31','MO');
The asp page will be able to parse multiple schedules supplied by a text file.
The second page is a result.asp 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.
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.