Show Bid Request
Parse a Text File and Export Parsed Information to New Text File
Bid Request Id: 36053
|
|
|
|
Posted by: |
sysdomatic (2 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 0.00%
|
Buyer Security Verifications: |
Good
|
|
Approved on: |
Nov 18, 2002
8:58:33 PM EDT
|
|
Bidding Closes: |
Nov 19, 2002
10:00:00 PM EDT
|
|
Viewed (by coders): |
361 times
|
|
Deadline: |
11/20/2002
TIME EXPIRED
|
|
|
|
|
Description:
I need the included text file to be parsed, and returned as a *.sql file called onet.sql. All I need back is the SQL file, however you code this is your business. Basically, I have a large 900 entry text file which has job codes, job titles and job descriptions. I need this information imported into a mysql database, yet some of the information I don't need. Let me demonstrate what I mean. Here are two sample lines from the file:
17-3019.99 Drafters, All Other All drafters not listed separately.
19-1029.99 Biological Scientists, All Other All biological scientists not listed separately.
I need this information exported to a *.sql file in this format:
INSERT into ONET (idtag, jobcode, jobtitle) VALUES ('17', '17-3019.99', 'Drafters, All Other');
INSERT into ONET (idtag, jobcode, jobtitle) VALUES ('19', '19-1029.99', 'Biological Scientists, All Other');
So as you can see, the idtag is simply the first two numbers of the job code. So, if the code is 29-3019.99, then the idtag is 29. I need all 900 of these job written to the onet.sql file in this format.
Deliverables:
All I need back is an onet.sql file, in the format I listed above. You can keep the source code you used, I don't need it. Just the new sql file that was created.
Platform:
Doesn't matter, I simply need the onet.sql file back.
Must be 100% finished and received by buyer on:
Nov 20, 2002 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.
Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
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.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
This bid was accepted by the buyer!
|
$15 (USD)
|
Nov 18, 2002
10:30:18 PM EDT
|
9.55
(Excellent)
|
|
|
I have attached the file. Incidentally, I imported it into excel, and excel split it into columns for job code, title, desc. I then split the job code by the '-' and got the extra column. I then used this formula:
='INSERT into ONET (idtag, jobcode, jobtitle) VALUES ('' & A2 & '','' & A2 & '-' & B2 & '','' & C2 & '');'
|
|
|
Attached File
|
|
|
|
|
|