I have a single column list of performers (alphabetical) and their releases (not alphabetical). The performers names are in all caps. The release titles are in mixed case. What I'd like is for all of the performers names to be in Column A (alpha) , and the release titles for each performer listed one line down in Column B (alpha). Example: Raw data - Col 1 ALL MIGHTY REJECTS When The W...
Hi everyone, We need to create a new website, which consists of comparing and recommending prices. The idea basically is to import list of products and prices of * .xlsx files and import them through a management panel. The application consists of 2 portals. the first one is for users who enter the platform with credentials, when they enter they will
...Programs and Graduate Programs in Australia. We just need as much information as possible, and will pay hourly for work. We need the data on a spreadsheet in either .csv, .xls or .xlsx formats, which are easily stored and moved around/manipulated in data sets. The information we require is: Company Name: (e.g. KPMG) Role: Graduate, Internship, Vacationer
I need Word (doc,docx), Power point (ppt,pptx), Excel (xls,xlsx), PDF, Html and text Reader. File open within application.
Hi, I have an online store [login to view URL] on Drupal 7 with commerce module, and I nee...[login to view URL] on Drupal 7 with commerce module, and I need to make some futures for it: 1. facet filters in all categories pages (about 15) 2. updating product availability using .xlsx files. 3. improving page speed. If you interesting this project, I can explain more.
Summary: We require a basic web page to display...are able to be previewed (within limitations). This limitation is up to you, however, as a starting point most files that exist are one of the following: • PDF • DOCX • PPTX • XLSX We expect you to advise us what is possible BEFORE commencing any work as this may affect our decision to proceed.
I need you to develop Android app source code for me. I would like this app to be developed using Java that i can open in android studio. Fea...downloaded files in a recyclerview in My downloads section in the app. 4. Click file name in My downloads to open the file. 5. File types include jpeg, png, gif, mp4, mp3, aac, pdf, xlsx, docx, pptx, apk etc.
...not a big job for someone experienced in Powershell. The scripts job is to look in a folder and its subfolders specified by the user and find any out of date, DOC>DOCX, XLS>XLSX, PPT>PPTX or PPTM and any out of date PDF files and convert them into their respective newer versions in another folder (also specified by the user) that retains the file structure
I need to pull data from a legacy Cobol application. I don't have much information about it, but...information about it, but I know it relies on .vix and .dat files for its database. What I need is a consulting about the better approach to extract data from those files and create csv files. The goal is to populate a SQL database with that legacy data.
...product by SKU and at the same time it updates the quantity product, product title and product price. This works great. It uploads xls file (it most be excel related xls and xlsx file type). Now we need a pro developer who can fast update this component with adding a new products. It means: the all active products should be updated by the SKU with product
...page you will find two things a. a set of long and lat defining a polygon for the city name provided. a: you will get those long and lat and put in a CSV file as one record in the following format City Name, Sub City Name, Date Retrieved, State, Points of polygon (would be lat , long | next point....)
...Read files, Update text in the file, Create copy of existing file, Read spreadsheet, Update spreadsheet cells Here is flow diagram - [login to view URL] NPM package XLSX needs to be used to read write spreadsheet. A clear spec with flow , folder strucutre diagram , detail steps with diagrams, test data and sample output file will be provided
...you to develop some software for me. I would like this software to be developed for Windows using Java. Write a code reading the useragent information from xlsx file and generate the output xlsx file with the browser, os, actual browser by comparing the general useragent string with the rows given in excel file. Then Write a testcase to compare both
...SUM to a column of data in cell next to cell TOTAL I copy name from a cell (always in same cell location) I add name from cell to file name to save. I change SAVE from .CSV to .XLSX Can make me macro for this? Cost? I can make a video recording of what needs to be done...
...built from one xlsx and one csv sheet. We need to compare the information based on one or two relationships and spit out very specific information from both sheets. We are accomplishing this with a VERY programming heavy Excel sheet currently and we already have too much information going in for this to be time effective. One form (csv) is updated weekly
...aux_reason file I would like to see agent-wise all the reasons listed in the columns C-O - from the weekly4 file I would like to see language-wise all the data - from the 29.xlsx file I would like to see agent-wise the login and logout time (if 1 agent is logging in and out several times per day, I would like to see the first login and the last logout)
...displayed as -negative figures, not auto-matching with Zoho. What you are required to do will be : - Books -> Banking: you will check all the data from my bank (will provide .CSV export from a set date) will be coherent to a) what exported from Debitoor so far and imported to Zoho so far b) you will match all my transactions with banking / invoices /
PHP or similar script (to be used on a website) Have a data feed that is in XML/csv format and it needs to be converted to csv with some fields being removed (or not copied) and mapped/aligned with new columns and data population Once initial file created, when script is ran daily it needs to compare each field, if QTY has gone to 0 or item removed
I have xlsx file with 208k email addresses. I need help to test this list 1. you must have email marketing software (Interspire, Active Campaign etc.) 2. Import list to email marketing software 3. setup campaign acction to filter emails 2 diferent lists (email opened and link clicked) 4. send text based emali with link (I will give it) 5. screenshot
I need a PHP script that will allow a user to select and upload a csv file and then map the csv data to the correct fields in the database. During the import process I need the script to either insert a field into the csv file (subuserid) OR insert the subuserid into the imported records. The subuserid field is coming from a cookie. The data that
...compiling data from several PDF files into one XLSX file. There is one document number and date per PDF as well as several line items. I attach two self-explaining files (one sample-PDF with comments and one XLS file which should be the final result). I got 51 PDF files that need to be compiled to one XLSX. Some PDFs are larger (maybe up to 100 items
I want a macro/VB to be build to convert XLSX/XLS file of a specific format to a csv format. some basic formula to be build as per the input and output file. This XLSX/XLS file data will keep changing, so whenever we run the macro, csv file should generate. It's a simple requirement.
...will get: - the updated Listmanagement Plugin - the onpager-plugin to test and demonstrate you functions 2.) Usability improvements As we discussed with Prabal we will use as XLSX-Download the following Class (new): [login to view URL]
combination of AES 256 bits with MD5 than just using AES only. While the document file containing graphic data such as *.docx, *.xlsx, *.pptx, *.pdf then encryption using only AES 256 bit method faster than using AES 256 combination bit and MD5
convert xlsx-File (with special characters) in csv
...time consuming process. Requirement • Create a new page on the wordpress website • This page should have a file upload box • This file upload box should only accept .xls or .xlsx files • This file upload box should only accept correctly formatted files. • On upload any product data that has an existing entry in the existing product database should be
...database + make csv output file of only the modified data. Project description. Master Excel database has about 35000 products. Each product showing many columns of product details. One small program (executable) need to be written that does the following: 1. Get the new files from my supplier from a FTP location (about 13 csv files from a list
group the excel file by name,ip,cost insert into trunks_trunk (name,cost,ip,descr,template_id,max_count,trunk_type,priority) ### these are the grouped values tr...ext_prefix in xls insert into trunks_rules (trunk_id,ext_prefix,add_prefix,strip,allow) Example mysql and example xls attached Keep in mind that i want this for csv, xls and also xlsx
Hello, I want to copy 8.00...type:metric,,name:actual_12b1,type:metric,,name:administration_fee,type:metric,,name:transaction_fee,type:metric,,name:incorporation_country,type:infoField And send me then the xlsx file. You should continue below the file attached and the first one it should be: M:[login to view URL] Fidelity AsiaStar Series A CAD 92 98,31% 2%
...Type” in the reference sheet it should default to a “Category Type of “Uncategorised”. 3. Sort, filter and extract relevant data (indicated in the attached file “XML Map 1.1.xlsx”) - This will includes splitting the Product to show the modifiers (these are separated by a “+” and I have given an example in the attached file “Product M...
- Need a sample program (app) in ionic which transfer file to a remote sever through ftp or file copy - File extensions .docx, pdf, xlsx - Max file size 10 MB - After file is transferred "success" message to be printed on app view. - Should give path to file in call back to view which submitted the file. Steps: - View with browse button to select
...possible. If there is something that seems unclear, I can help out with translations. I need this done as soon as possible for a reasonable prize tag. 1. The datafile uppgift1.xlsx contains samples of information about visitors to a website, every individual sample note if they have converted and made a purchase or not. Create a confidence interval of
I need you to develop some software for me. I would like this software to be developed using Java. Make a function that is able to accept user input and d...between the different data types. For example, photo formats(jpg,png and more), video formats(mp4,mov and more), audio files (mp3 and more), document formats (.txt, docx, pptx, xlsx, pdf and more)
Hello, i have a .xlsx file that I need imported into my Hikashop back-end database. it contains Hikashop orders. I need these orders imported to my Hikashop back-end MySQL database. Joomla is the front-end, and MySQL standard Hikashop set-up on the backend.
...believe their data will be useful to me. As part of my membership I can download in .csv format all of the data that has been published since I joined, and I can view online their earlier data. For some reason they are unable to make the earlier data available in csv format, but I need a substantial amount of it for analysis purposes. There is a massive
Hi there, I am after someone who can assist scrape share price related data and information from two different websites and bring those toge...regarding the project as this helps me see that you have read and understood the project. Attached is an example of the data I would need to have pulled, file 'Share Deets (1).xlsx' Thanks for applying. Luke
Please read carefully the tasks a...can't complete the work today, it will be pointless and a waste of time for everyone. [login to view URL] Website url in dev server: [login to view URL] Backend access will be provided once project is awarded. Thanks.
I have a vlookup forumla which searches one sheet i want it to search the whole entire workbook =IFERROR(VLOOKUP(C2427,'SL05'!C$2:...sheet i want it to search the whole entire workbook =IFERROR(VLOOKUP(C2427,'SL05'!C$2:M$3010,11,),"INSTOCK") Its searching only sheet "SL05" i want it to search the whole xlsx workbook which named 2018 - [login to...