ASP Parse Data in SQL Statement

ASP code to parse and redraw monthly schedules [login to view URL] 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 [login to view URL] 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