I need an Excel program that will compare two CSV files and return the results. Our bank receives about 150 checks per day. The bank captures all the information on the checks (the check #, the check amount, the remittance information) and supplies us with a CSV of that data. We then take that CSV and upload it to our accounting system. The accounting
The project is to create a Python script that will read a CSV file (sample attached) and convert all the dates from one format to another for all the rows in the CSV file (variable length on number of rows). The date is always between the second and third semicolon and it is shown in this format: Sun Mar 11 00:00:00 CET 2018 I need it to be shown
...an AWS Lambda function. CSV files can be upto 100 mb so need the ability to handle large files, while keeping the Amazon memory foot print minimal possible. 1. Trigger as file detected in a S3 bucket 2. Load the data from CSV into a table in MySQL database a. If table does not exist then create it using headers in CSV as column names | Table
I need two functions, ExcelXMLSpreadsheetToVbArray(strstrExcelXML,arrVB) and VbArrayToExcelXMLSpreadsheet(arrVB) pseudocode: Function ExcelXMLSpreadsheetToVbArray(strstrExcelXML,arrVB) .... Redim arrVB(intRowCount,intCellCount) .... ....Fill array with Text from Row,Cell End Function Function VbArrayToExcelXMLSpreadsheet(arrVB) Dim strXML strXML="<?xml version="...
1 small Program in Vbscript that Append a txt or csv file, into a SQLite Database table. Records are already sorted by Date. 2nd Program that access a table with HTML/VBScript (or Java) display records details by User, Device and a Dashboard with totals x month. A 3rd Program HTML/VbScript that appends new records on screen to a different Table
I am working on a machine learning / deep learning project and I am experimenting with various datasets. Each project could be handled by a different contractor. Or we could develop an ongoing relationship. Price will be function of # of records returned. Examples: (1)insurance agencies (companies) on yelp: name, address, telephone number, website, each review (date, who did it, the number of r...
I need to create a mail merge from Word to fill a form and some smaller spreadsheets from a regular csv created from a project management software report. The output currently needs editing in between with excel to change some formats such as dates into dd/mm/yyyy formats and a time field that comes out as eg 9:00am, 9:20am, 9:40, etc which need to
For Shopify :_ i want change FIELD in Proudct upload CSV according me.. Like I could have Product option Rather then 3 may be unlimited.. or u may give me wysiwyg one page script
...somebody who is skilled in PowerShell scripting. We get an *.xls file, which your script should: 1. convert to csv 2. one column (A3, B3, C3 and so on) contains values like 1,2 or 3. these should be multiplicated by 5; so add a column to the csv file where x = A3 * 5 3. save it as csv We have a lot of these small projects and tasks so if you are
Hi, i am looking for someone who is able to adjust some .csv product-data so that they work in woocommerce. I want my woocommerce shop to be fully connected to the EDC Wholesale Dropshipping. Therefore the .csv data must be adjusted so that i am able to import products to my shop and that orders are fulfilled automatically via API. Please
Tasl: Convert an CSV data file into MT940 format for Rabobank The CSV file contains bank transactions. This needs to be converted into MT940 format. Prefer Freelancers who work in the banking and finance industry and thos ethat are experts in SWIFT messaging and MT940. Computer experts and payments experts please apply. Please qualified
I need a PHP file which read a specif [url removed, login to view] file with 2 or 3 JSON instance and convert each instance into a csv file in the same folder.
...reused, duplicated and modified - to be checked. it should do the following: - let me import/upload a CSV - let me enter a Title header text (string 200 characters) - delete several columns (i will provide column numbers to delete) - in column 9 the CSV has a number which is used in odoo data in "invoice reference" field. - Search for the correspoinding
So I have an ecommerce store selling gifts. One of my suppliers offers XML and CSV files and says I can add a Live Feed, so my site's stock level will match my suppliers stock level automatically. Here is some info the supplier offers: [url removed, login to view] I'm using WooCommerce on WordPress, self hosted. Criteria
We need a freelancer versed in php, that can develop a php script to compare two different csv files, they have different headers, but the columns content is similar so it needs to map it, for instance header a in the first CSV it's different from the header in the second, and might also be in a different column, but similar content will be shared,