Parse text file and extract and reformat data to CSV

Budget $30 - $250 AUD
Bids 27
Average Bid $112

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.

Post a Project Like This

This project was awarded to

weonlydo

Richard was extremely professional and great to work with. He delivered my project in a timely and proficient manner. Further, he was extremely quick in responding to my questions and addressed them clearly. Also, the work was professional-level and he delivered exactly what I needed with little direction. I would highly recommend Richard for future work and I look forward to working with him in the future.
About the Freelancer
weonlydo Profile Picture

I am a freelancer domiciled in New Zealand. Don't let my time zone fool you though - I work around the clock and can adjust my schedule to work around your project. My core strengths are programming, APIs, scripts, macros, diagnostics, server administration, troubleshooting ... have I just covered all aspects of IT? I have been in the industry nearly two decades and have done all sorts of projects from front end through back end and the middleware in between. Check out my reviews and completion rate, then judge me for yourself when I complete your project. I apologize to the stones that WILL be turned to uncover the solution to your problems, none shall be spared!

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • meyevue Profile Picture

    meyevue

    Sydney,  Australia

    mEyeVue Software & SystemsDesign Engineering has very broad technology industry based experience with a proven record working in industries that include data communications, telecommunications, contact/call centre technology and e-commerce. Platform expertise includes Linux systems administration, C, PHP, HTML, JavaScript. Database expertise includes mySQL and Postgresql. mEyeVue Software & SystemsDesign Engineering has extensive business analysis experience providing highly effective consultation between the business, end-users and technical teams. With a strategic eye for successful project outcomes we have set up highly successful project management practises in large corporate and SME environments in accord w ith the optimal approach for these differing environments. mEyeVue Software & SystemsDesign Engineering has extensive experience in and understanding of technology development projects and processes, systems design and product delivery & development, providing strong technical leadership to technology development teams.

    PHP, C Programming, Javascript, and Visual Basic

  • cmcs Profile Picture

    cmcs

    Port Elizabeth,  South Africa

    15 Years Development Experience Drupal and PHP Expert I do things quick and right the first time!

    Javascript, XML, Python, and Script Install

  • ccpplinux Profile Picture

    ccpplinux

    MUZAFFARPUR,  India

    I am Pankaj Kumar. I have been working as a freelance web developer and trainer since 2004 using LAMP tools. I am involved in the Open Source Software Development Activities as well as providing training of tools of this environment. I am maintaining GNU/Linux User Group for my home town, namely, Muzaffarpur which is situated in the Bihar state of India. I am also associated as Faculty Member with the MCA (Master in Computer Applications) Course Department of Babasaheb Bhimrao Ambedkar Bihar University, Muzaffarpur, Bihar, India. I am also working as Course Coordinator of M.Phil.(Computer Science) in Directorate of Distance Education, Babasaheb Bhimrao Ambedkar Bihar University, Muzaffarpur, Bihar.

    PHP, C Programming, Javascript, and XML

  • weonlydo Profile Picture

    weonlydo

    Auckland,  New Zealand

    I am a freelancer domiciled in New Zealand. Don't let my time zone fool you though - I work around the clock and can adjust my schedule to work around your project. My core strengths are programming, APIs, scripts, macros, diagnostics, server administration, troubleshooting ... have I just covered all aspects of IT? I have been in the industry nearly two decades and have done all sorts of projects from front end through back end and the middleware in between. Check out my reviews and completion rate, then judge me for yourself when I complete your project. I apologize to the stones that WILL be turned to uncover the solution to your problems, none shall be spared!

    PHP, Perl, ASP, and Java

  • SigmaVisual Profile Picture

    SigmaVisual

    Taxila Cantt,  Pakistan

    Web, Bots, Crawlers, and Scrapers Development. I have expertise in automation services and I can automate any manual process.

    PHP, ASP, C Programming, and Javascript

  • virtual7 Profile Picture

    virtual7

    Kiev,  Ukraine

    I don't need a payment if I can't get the work done.

    PHP, Javascript, Website Design, and Graphic Design

  • szymszteinsl Profile Picture

    szymszteinsl

    Krakow,  Poland

    Hi! I am professional C/C++/Java programmer. I can do your projects with highest satisfaction! Best Regards, Szymszteinsl

    C Programming, Java, JSP, and Javascript

  • xpoh Profile Picture

    xpoh

    Minsk,  Belarus

    I have 10+ years in web development with PHP, MySQL, AJAX

    PHP, Perl, Javascript, and Script Install

  • toinnisfree Profile Picture

    toinnisfree

    IKOTA LEKKI AJAH,  Nigeria

    I am a fulltime freelance programmmer with over 10 years programming experience. An expert in PHP / MYSQL / Javascript / AJAX / XML deployments. I particularly specialize in shopping carts and API integrations: payment, shipping, inventory, autoresponders and the like: Interspire, Zencart, Virtuemart, Cubecart, Amember, OSC, TomatoCart, Woocommerce. You will find my services highly reliable and professional. Let me get right to it and deliver your next project with a professional quality that many of my previous customers can attest to.

    PHP, Perl, C Programming, and Javascript

  • rajeshsonisl Profile Picture

    rajeshsonisl

    Mumbai,  India

    Hello, Thank you for dropping by. =============== Why choose me? =============== I ... ...have a total programming experience of over 17 years (including 9 years in PHP - MySQL). ...take pride of my 5.0 / 5.0 rating, 98 - 99% completion rate, 100% on-time completion. ...work alone, and strictly bite only what I can chew! No sub-contracting, ever! ...use most instant messengers for speedy communication, and always backup files that I change. ...provide daily progress reports / updates via Skype (Google Talk, Freelancer or email), whatever YOU prefer. When it comes to automation, I make it a point to apply automation techniques wherever applicable. I believe in working the smart way; that makes me work smart, and not hard! Started programming in the year 1997, and still trying to maintain the rating, from almost 900+ on-record projects! Thank you for reading. Have a good one :-)

    PHP, Java, Javascript, and XML