Find Jobs
Hire Freelancers

CSV Database Modification

$30-250 USD

完了済み
投稿日: 約12年前

$30-250 USD

完了時にお支払い
I need some help modifying a large CSV sheet to help fill in gaps in the “Date” column. Currently, the date skips ahead between 5 and 7 days at a time. The date is in the format YYY-MM-DD. So 3 rows might look like: 1987-01-08 Title A 1987-01-15 Title B 1987-01-22 Title C I would like the days between present dates to be added and to copy the Title data from the previous date. So using the above example, it would now look like this: 1987-01-08 Title A 1987-01-09 Title A 1987-01-10 Title A 1987-01-11 Title A 1987-01-12 Title A 1987-01-13 Title A 1987-01-14 Title A 1987-01-15 Title B 1987-01-16 Title B 1987-01-17 Title B 1987-01-18 Title B 1987-01-19 Title B 1987-01-20 Title B 1987-01-21 Title B 1987-01-22 Title C 1987-01-23 Title C 1987-01-24 Title C 1987-01-25 Title C 1987-01-26 Title C 1987-01-27 Title C 1987-01-28 Title C There are 2,606 entries in total, all of which are formatted like the first example. They all need to be changed to fit the format of the second example (adding dates, copying titles) which will result in approximately 18,000-19,000 entries total. Some of the entries will have the same title as previous entries (Title A might be the title for 4+ weeks, for example) and should be treated the same and copied forward to the following week. There are only the two columns in the .csv, no other data needs to be considered. I can send a small sampling of the actual .csv data on request.
プロジェクト ID: 1406653

プロジェクトについて

18個の提案
リモートプロジェクト
アクティブ 12年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
If you need also the macro doing this job then I'll send you it together with the result CSV file. Regards
$30 USD 0日以内
4.9 (64 レビュー)
5.7
5.7
この仕事に18人のフリーランサーが、平均$45 USDで入札しています
ユーザーアバター
Hi. Modifying database by placing missing date with the specific category within 24 hours. Please check private message for more details. Thank you
$50 USD 1日以内
4.9 (436 レビュー)
8.6
8.6
ユーザーアバター
Easy Task but time consuming,I can do it..please check pm for details...Thanks
$30 USD 2日以内
4.9 (677 レビュー)
8.4
8.4
ユーザーアバター
This is really simple. Award the project and send me that file. I'll deliver it in 1 hour. Many Thanks!
$30 USD 1日以内
4.8 (113 レビュー)
7.1
7.1
ユーザーアバター
I can do this for you. See PM for details.
$30 USD 0日以内
5.0 (212 レビュー)
6.9
6.9
ユーザーアバター
Dear sir, completed file would be clean and accurate. For details please check PM. Thanks.
$35 USD 1日以内
4.8 (191 レビュー)
6.7
6.7
ユーザーアバター
Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)
$30 USD 1日以内
4.9 (66 レビュー)
6.0
6.0
ユーザーアバター
Can I have the sample file?
$30 USD 1日以内
4.9 (83 レビュー)
5.8
5.8
ユーザーアバター
Please see a robust solution on PMB. Regards
$90 USD 3日以内
4.6 (5 レビュー)
4.6
4.6
ユーザーアバター
Can do this task in 2-3 hour.
$30 USD 0日以内
5.0 (6 レビュー)
4.4
4.4
ユーザーアバター
Good day, I can do this job.
$30 USD 3日以内
5.0 (6 レビュー)
2.6
2.6
ユーザーアバター
Hi, this can be done in 5 minutes.
$30 USD 0日以内
5.0 (3 レビュー)
2.1
2.1
ユーザーアバター
Hi, I am interested in this job posting. Please check PMB. Thanks
$35 USD 1日以内
5.0 (3 レビュー)
1.4
1.4
ユーザーアバター
Hello Please read more than private message thank you
$50 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi i am bidding n your project.
$150 USD 15日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi Sir, I read your all of the details of your Project. I have two years experience as a virtual assistant, and I am able to do this project in less days... Please read PM... Thanks
$50 USD 5日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I need to fill the date as per the instruction given above.
$30 USD 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I can do this very quickly and easily. here's my profile: My expertise includes developing tools, systems and applications (using MS Access, VBA, SQL, MS Excel, macros and modules), building customized financial models (using MS Excel/VBA), creating financial models and stress test scenarios to measure investment and portfolio risk, creating custom reports using native Excel functions and customized macros, using VBA to connect to other MS Office Applications, databases, and data feeds etc. Examples of completed projects include the following: > AmerisourceBergen Corporation needed a sales compensation management system for nealy 500 persons receiving incentive compensation payments. In response, I developed a Compensation Management System that helped analysts and accountants maintain detailed employee records and related compensation plan data including performance metrics for each employee in each role over a three year period. System included modeling capability which allowed senior executives to determine the annual costs/savings of various changes to compensation plan metrics. > Johnson & Johnson needed a system to manage suppliers. In response, I developed a customized Supplier Management System (utilizing my MS Access, VBA, ADO skills) enabling company buyers to track suppliers, contacts and raw material items purchased from suppliers. Result: Johnson & Johnson buyers can quickly access supplier historical data and track changes in supplier name and supplier contacts. > Johnson & Johnson needed to trace the origin of manufacture for raw material items purchased from Suppliers. In response, I developed a small application that uploaded raw material items data received from Suppliers on MS Excel spreadsheets into MS Access. The inputs received from Suppliers were harmonized and validated through numerous tools and reports created. Result: Users can determine the country of origin for the raw material items. > I developed for JPMorgan Chase an application that generated a series of customized reports. Reports are based on data gathered from a backend SQL Server database via ODBC queries via stored procedures and complex SQL queries. Reports are exported to MS Excel workbooks. Additional reports are generated within Excel by extracting data from front-end Access database via ODBC queries and SQL statements.
$49 USD 1日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

CANADAのフラグ
Broomfield, Canada
5.0
6
お支払い方法確認済み
メンバー登録日:2月 24, 2010

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。