ASP Parse Data in SQL Statement
$30-100 USD
Paid on delivery
ASP code to parse and redraw monthly schedules
[url removed, login to view]
Input :
#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]
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,','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 [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
Project ID: #2896931