ASP code to parse and redraw monthly schedules 
Parse.Asp 
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 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.

								

									
									
												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

										

										

										Must be 100% finished and received by buyer on:

										Jan 15, 2003 EDT

										Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5).  If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.

										

								

										
										Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.  
If you notice a violation please help out the site and report it. Thanks for your help.