Parse text file and extract and reformat data to CSV

Closed

Description

I need a simple script that will read files in the format of "[url removed, login to view]" attached.

From this file, the transactions need to be read, and the output reformatted to csv.

You will need to read through the [url removed, login to view] file until you get to "Statement Opening Balance" then read the amount after this. The transactions to be output follow this between lines of "......".

For each transaction you need to extract the date, and then the description, and then the transaction amount, and then the new balance. Using the transaction amount and the previous balance and the new balance you will need to determine if the amount is a debit (reduced the balance) or credit (increased the balance).

The transactions should be read until you reach "CLOSING BALANCE"

The output file will be in CSV, and in the following format:

Bank Account,Date, Description, Debit Amount, Credit Amount

The bank account will be the same for every line and will be able to be determined from the text at the start of [url removed, login to view] by reading the line under "BSB Account Number" and removing any "-" or " ".

The date will need to be changed from the [url removed, login to view] file being in "DD MMM" format, to DD/MM/YY when output to the csv. The year can be determined from the line that included "Statement Opening Balance".

The script should allow for the source file to be uploaded by the user and the output csv to be downloaded.

Skills: PHP

See more: reformat data, yy, mmm, php read text file, parse lines file, csv text file, php output csv, parse data file, source file, line csv, csv bank file, read txt file php, parse data csv, php reformat csv, php extract bank, php parse csv script, script extract data text file, php bank transactions, transaction data, php script parse csv, script account balance php, extract text csv, php bank account script, extract text php files, php script parse file

Project ID: #4999349

Awarded to:

weonlydo

Hi from across the ditch! This file will not be a problem to translate. The UI: single file selector, choose, then click "Upload" button. Result: A download link (or automatically download) There are some curli More

$75 AUD in 2 days
(35 Reviews)
5.6

24 freelancers are bidding on average $111 for this job

toinnisfree

I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactor More

$100 AUD in 1 day
(549 Reviews)
7.9
SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: http://sigma-dns.sigmavirtual.com/PDemo1/Am More

$144 AUD in 3 days
(235 Reviews)
7.8
flashzeus

Hi! My name is Denis. I'm expert in programming. The task is clean I ready complete it within 2 days from the start. Denis. With best regards.

$94 AUD in 2 days
(140 Reviews)
7.4
rajeshsonisl

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

$103 AUD in 1 day
(432 Reviews)
7.2
rinsadsl

Dear customer I can do this job for you. I clearly understood the requirements and will created the necessary CSV file from the source.txt file. Looking forward to hear from you. Thanks Rinsad

$83 AUD in 2 days
(254 Reviews)
7.0
ccpplinux

Hi, Thanks for placing such a nice project which involves the bacnkend coding in PHP. I can easily develop a PHP script for this project very easily. You need to just accept my bid and I will do the rest. Best Rega More

$83 AUD in 3 days
(115 Reviews)
6.9
eelance

i can do that for you. how many files are there? have done many projects in here. it is not problem for me do that .

$111 AUD in 3 days
(331 Reviews)
6.8
ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert desktop software/macro/bot/ More

$100 AUD in 1 day
(75 Reviews)
5.9
ebson

Hi, I have an extensive experiance with text processing. your requirements is very clear and so I am ready to start once you select my bid. project will be done in one day with two days after that left for you to te More

$84 AUD in 3 days
(25 Reviews)
5.5
virtual7

I am ready to start. Will do it properly and will not require any payment until it is 100% done. Thank you.

$105 AUD in 2 days
(32 Reviews)
5.0
cmcs

Hi there, I have had a look at your requirement, and the attached file. I have 12 years experience in PHP development. From the source file I am able to determine the Bank Account Number, Date, Description, De More

$216 AUD in 2 days
(53 Reviews)
4.9
szymszteinsl

Hi! I see that you still looking for rpogrammer for this project, i can solve this with my new partner Best Regards, Szymszteinsl

$250 AUD in 3 days
(12 Reviews)
4.9
stevecorsi

Hi jaysonai, please let me do this for you ? please let me do this for you ? please let me do this for you ? please let me do this for you ? please let me do this for you ?

$55 AUD in 1 day
(18 Reviews)
4.8
mmadi

Hi, I'll be happy to do that for you. I have rich experince in scrapping using curl regular expressions and Dom Examples of work: http://www.travelfox.com/ http://www.morethanman.com/ http://www.dcdouglas More

$155 AUD in 3 days
(13 Reviews)
4.8
eComOS

Hello jaysonai, I have read your requirements, I am very confident to do this project. I GUARANTEE COMPLETE SATISFACTION before payment. ✓ 5/5 RATING, ✓ 100% COMPLETION RATE, ✓ 100% ON-TIME COMPLETION, ✓ 100% ON- More

$98 AUD in 1 day
(34 Reviews)
4.5
mdrolc

Hello, Sir! I went through requirements of your project. I realize we're talking about extraction of data from multipage bank statement. I've been working on an accounting application for several months and this is More

$77 AUD in 3 days
(3 Reviews)
4.2
dpune

Hi, Do you need web application or desktop application ? I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me More

$111 AUD in 3 days
(21 Reviews)
4.1
meyevue

Looks straight forward enough! Out of interest, from my experience the Westpac online banking lets you output your account balances to a .csv file which you can then open in Excel? - so you are not looking to re-i More

$277 AUD in 3 days
(2 Reviews)
3.9
RITESHBATHWAL

Hello Sir, I am an expert in PHP and can do this job very easily and fastest for you. PLease award and you will not be disappointed.

$60 AUD in 3 days
(22 Reviews)
3.8
realimaginations

Hi, I have done various core php applications as well as some of the project similar to your project. So ready to start . Let's discuss! thanks!

$133 AUD in 2 days
(16 Reviews)
3.8