I need a vb.net 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 3.6155 3.8423 3.9098 3.0297 3.4987 4.0843 3.6383 2.9978 3.2785 3.9895
The dataset needs to contain the following columns:
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!
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).