Em Andamento

[url removed, login to view] dataset from textfile

Hello everyone,

I need a [url removed, login to view] 2005 program that will read a textfile (example attached) and parse the text line by line into a dataset. I need to be able to use SQL select statements to later retrieve the records.

An example of a line in the file looks like this: Serum_0.3_1440_HCT116_3_1 [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view]

The dataset needs to contain the following columns:

Treatment

Dose

Time

Cell

Bioreps

Techreps

Values

I need to be able to parse the first value (in the example above, this is: "Serum_0.3_1440_HCT116_3_1") into the form:

Treatment_Dose_Time_Cell_Bioreps_Techreps. The value column needs to be filled with the remaining portion of the line as a string.

The example file has 1025 entries, so that means there should be 1025 records in the dataset.

The real task that I need it to be able to execute SQL commands on this (I.e. SELECT * FROM Table WHERE Treatment = 'UV').

Note: I DO NOT have an SQL server available...I need this program to be portable from computer to computer...including computers without MS Access. Is any of this possible?

When bidding, please give me a little bit of info as to how you will be doing this...that way I know you understand what I need and I can choose a better coder that way. Also, please provide an estimate as to how long this might take. I need it asap, and will gladly give a bonus for speed!

All questions welcome!

-Brett

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

[url removed, login to view] 2005

Win XP

Habilidades: .NET, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, Visual Basic

Ver mais: vb note, net program code, net hire, use net, read computer code, example net, 9895, portable package, e vb, sql commands, sql retrieve table, php string contain, program basic string, bidding site net, portable executable, means net, read file table access, access read file table, filled asap, visual basic text column, code read net, php execute commands, text column visual basic, questions net, statements know

Acerca do Empregador:
( 57 comentários ) United States

ID do Projeto: #3021237

Premiar a:

gromknight

See private message.

$25.5 USD em 5 dias
(37 Avaliações)
4.5

2 freelancers estão ofertando em média $26 para este trabalho

felpo

See private message.

$25.5 USD in 5 dias
(4 Comentários)
2.8