ASP Parse Data in SQL Statement

Completed Posted Jan 7, 2003 Paid on delivery
Completed 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

ASP Database Administration Engineering MySQL PHP Software Architecture Software Testing SQL Web Hosting Website Management Website Testing

Project ID: #2896931

About the project

8 proposals Remote project Active Jan 31, 2003

Awarded to:

hsedidin

See private message.

$28.9 USD in 14 days
(36 Reviews)
4.6

8 freelancers are bidding on average $45 for this job

alokgarg

See private message.

$12.75 USD in 14 days
(69 Reviews)
4.2
techjunc

See private message.

$42.5 USD in 14 days
(21 Reviews)
3.6
visiontechvw

See private message.

$76.5 USD in 14 days
(3 Reviews)
3.4
pseudocodevw

See private message.

$85 USD in 14 days
(16 Reviews)
3.2
xcodervw

See private message.

$25.5 USD in 14 days
(6 Reviews)
3.0
juggyvw

See private message.

$63.75 USD in 14 days
(4 Reviews)
2.1
raysoftindiavw

See private message.

$21.25 USD in 14 days
(0 Reviews)
0.0