Find Jobs
Hire Freelancers

File conversion script needed- IIF-->CSV/EXCEL

$10-30 USD

Completed
Posted almost 3 years ago

$10-30 USD

Paid on delivery
I'm looking for an easy drag & drop tool that will automatically adjust my .iff text files to a format that my QuickBooks Online importer can easily map. Specifically, my .iif files need the following modifications: 1) 2 column headers removed. 2) New column headers created. 3) First column removed. 3) Column order changed (although I *could* solve this by using custom mapping in my import too, instead). 4) A number generated (e.g. 1, 2, 3, 4, etc.) in a column that corresponds to each unique date. For example, for every row that has the date 4/5/2021, a "1" would appear in in the corresponding column; for every row that is dated 4/8/2021, a "2" would appear." The file can be re-sorted to make this easier. 5) File saved as .CSV or EXCEL. This solution must work on a Mac. I DO NOT CURRENTLY HAVE A LICENSE OF EXCEL and prefer Apple [login to view URL] for that work. I could also use Google Sheets or LibreOffice, if needed for your solution. My ideal solution would be an AppleScript involving Numbers.app. Please type, "This will work on Mac" in your reply so I can tell who actually read through the instructions. I will exclude anyone who does not include this attention to detail. I have attached before/after examples. Thanks!
Project ID: 30039510

About the project

1 proposal
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
This will work on Mac Hi I have read your requirements carefully I can make the app with python and Applescript related libraries to accomplish any automation using python in a GUI app I have good experience in python and data analysis I can perform all the requirements Let's talk about it more in the chat
$15 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Eugene, United States
5.0
11
Payment method verified
Member since Mar 16, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.