ASP Parse Data in SQL Statement

In Progress

ASP code to parse and redraw monthly schedules

[url removed, login to view]

Input :

#104 [OFF=16 #1] [CRD= [url removed, login to view] #3] [BLK=[url removed, login to view]] [TAFB=[url removed, login to view]] [CO= [url removed, login to view]] [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,','[url removed, login to view]','[url removed, login to view]','[url removed, login to view]','[url removed, login to view]','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

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

See more: crd-c, cod for, t-sql with, t-sql in, the parse platform, t-sql;, sample data, redraw work, parse, parse and, only 15 lines sample, it su, data source sql, data in, cod, atl, sample data input, sql javascript, sql created, insert variable, line asp, generate code database record, javascript code insert php, javascript insert text, parse javascript

Project ID: #2896931

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