In Progress

Program to parse a text report (csv) and convert into a usable flat file

We have a point of sale system that stores transactional information very poorly. I think it actually writes it to a string then stores it in a file.

Anyway, the data can be manually exported to what they call a "csv". I've attached a sample of the data.

We'd like the following:

A program to run nightly (we can use Windows Scheduled Tasks)

Searches a directory for new reports

parse the report for the core data

append said data to a database program such as access

We would need our table to have the following columns:

Transaction ID


Item Number (Item number and description are in the same cell - they need to be separate columns)



Unit Price

Extended Price

Customer Code

Customer Name


RxNumber (*item # 01 is a "prescription". the line below it "Reference:" has 4 "columns". we need the data from the 2nd column here. data from the 4th column goes to "customer code")

The sales data is found within the groups that say "Type: Sales"

Skills: Database Administration, Excel, PHP, Software Architecture

See more: parse reports program, text to string, file clerk, parse a string, flat price, flat line, convert access reports, call a, php flat file csv, convert reports database, point sale software code, transaction report, php csv sample, parse table, extended customer, php table csv, sales report access, flat file access, convert database program, parse csv string, convert text file report, csv convert, php parse string, access file convert program file, prescription data

About the Employer:
( 32 reviews ) Woodstock, United States

Project ID: #5063489

Awarded to:


Good day! I can help you provide the application using I am ready to start. Thanks and regards, Weng

$194 USD in 3 days
(753 Reviews)

14 freelancers are bidding on average $180 for this job


Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. More

$309 USD in 1 day
(822 Reviews)

Hello, I have done a similar job before. Ready to start. You can count on me for high quality work. Thanks, Alex

$175 USD in 3 days
(258 Reviews)

Hi, I'm talking about Windows tool (you can place it in Windows Scheduler) which will parse your log files and save info into Access database (or Excel file if you want). I have completed many desktop automation pr More

$55 USD in 2 days
(338 Reviews)

Hi, I'm ready to help you on this starting right now and finish ASAP. firstly the CSV file is not valid so I should fix it. then parse data and store it in database ! thanks.

$160 USD in 2 days
(104 Reviews)

Looking forward to working with you...Ready to start as soon as you are...Thank you for the opportunity...

$69 USD in 3 days
(76 Reviews)

Aucune proposition n'a encore été fournie.

$231 USD in 7 days
(24 Reviews)

Hello, I can help you. The data in the csv is not straightforward. It will have to be carefully extracted with a lot of intricacies. Best regards, AccuPro.

$200 USD in 3 days
(8 Reviews)

Have some questions and idea for you not export to csv at all. But it needs to be discussed. PM me if interested.

$166 USD in 7 days
(10 Reviews)

Good day sir! I'm very interested in this project and ready to discuss further for details. I'm looking forward to get your reply. Thanks and regards

$250 USD in 7 days
(1 Review)

We are Sql database [url removed, login to view] can take up your [url removed, login to view] details can be discussed in PMB. You can expect time bound results

$257 USD in 3 days
(2 Reviews)

Possibility in perl or php. Deliverable can be in mysql or mdb ( access ) As of now the CSV that you have posted looks like a normal text file.. it is not exportable to xls as csv file should..

$250 USD in 3 days
(0 Reviews)

I'll put a property in configuration which will contain the date & time of last execution. When you execute the application, it will read the last execution date and select only those reports which are created/modified More

$155 USD in 7 days
(0 Reviews)

Hello! I can do this job for you. I have great experience programming Excel, Word and Access. Your program can be done in Access or in Excel, and you can run it nightly. As I see it, it'll be better to place results in More

$55 USD in 10 days
(0 Reviews)