Concatenate jobs

As part of my project, I'm dealing with a large set of data (more than 10,000 rows) in Excel, for which I require professional assistance. Key Tasks: - Apply specific Excel formulas to perform financial calculations, including NPV, IRR, and ROI. - Utilize logical and text functions such as IF, CONCATENATE, and VLOOKUP for data management and analysis. Ideal Candidate: - Proficient in Excel functions and formula calculations - Experienced in handling large datasets - Strong financial analysis background The right freelancer will help me analyze this data successfully and draw meaningful conclusions. This project requires detailed and careful work due to the extensive dataset. I appreciate your time and consideration of this project.

Request from Mikel: "I need a small development. Ask for a password to load (defined in a file), and when you enter, it shows a log...with same structure. 2 types: 1) One or more URLs. It needs to show current listener and listener pick amount from 2 XML tag. If I set more than one URL, it should sum the amount of all of them (sum the numeric tags and show the total). 2) One of more URLs (different ones) from defined XML source. It's a table with 3 columns. It should show formatted. If there is more than one URL, it should concatenate and show the data of all of them together. They can be upto 50.000 or 60.000 lines. We won't use any database, the variables will be in a local file. If you need to download the XML files to process them, you can download it temporaly...

I'm working on a project that requires an expert with an understanding of facial expression recognition from three modalities and then concatenate them pairwise and then use deep learning model again utilizing deep learning models. - Development of Facial Expression Recognition: The core focus of the project is on creating a deep learning model capable of accurately and efficiently recognizing facial expressions in various media types. Ideal Skills: - Experience in Deep Learning: Background in developing and training deep learning models, ideally with some experience in image or facial recognition. - Understanding of Image Processing: Familiarity with various image processing techniques often used in combination with machine learning. This includes noise reduction, normali...

...) uses the MLT framework (or another equivalent open-source video editor like editly, FFAStrans, or even FFMPEG) to generate MP4 videos from existing video files that I've stored on Amazon Web Services (AWS). The core features of this web app should include: 1. Advanced File Processing: The software must parse an uploaded EDL file and then fetch needed video files from AWS to shorten and concatenate them based on the information in the EDL file (EDL files are human-readable text files). 2. Video Encoding: The capability to generate and export resultant MP4 videos with compression is a must. Suggestions include MLT, editly, FFAStrans, or implementation of FFMPEG. 3. Cloud Integration: After video generation, these MP4 files should be automatically saved to Dropbox or AWS...

... - If the audio file exceeds 25 MB, split it into 25 MB segments for processing. - Maintain the order of the segments for accurate transcription concatenation later. 4. Transcription with OpenAI API: - Send each audio segment to OpenAI's Speech-to-Text API for transcription. - Ensure that API requests are handled asynchronously and efficiently. 5. Transcript Concatenation: - Concatenate the transcribed text from each segment in the correct order to create a complete transcript. 6. Transcript Summarization: - Generate a detailed summary of the complete transcript using OpenAI's summarization feature. - Implement functionality to allow customization of the OpenAI prompt from the frontend. 7. Google Sheets Integration: - Use the Google Sheets API...

...Machine learning model code receives data and Request ID. Then returns prediction and the same Request ID concatenated with date time of processing. Response: id and prediction and date time Many requests are sent asynchronously in batches or continuously. When predictions are received: unique ID is used to match prediction and request and date time stamp to estimate delay time ( example :concatenate to id time of predictions for example ID = abc34bnm at time 20240211164320 , then together with data send to aws additional variable abc34bnm_20240211164320 returned receipt at time 20240211164324 is abc34bnm_20240211164320_20240211164324 ) ID to confirm it is the same request what was sent for prediction and time stamps enable to see delay just ideas

Please Sign Up or Login to see details.

looking for a skilled ABAP developer with some functional sd experience enhancement in program that push data from one structure to another structure, with some logic. concatenate json sting with one more key value pair. I am looking for a skilled ABAP developer to enhance our SAP system's capabilities by implementing a specific functionality for inventory data reporting. My goal is to seamlessly generate and access these inventory reports through the SAP GUI, ensuring an improved user interface for easier data management and decision-making. **Requirements:** - **Data Extraction:** Ability to accurately pull inventory data from our SAP system. - **Report Generation:** Skilled in creating reports based on extracted inventory data, presenting information clearly and effec...

I need an Excel expert who is skilled in developing macros or programs to automate specific operations on my data. Ideal candidates should have: - Experience automating data cleaning and formatting processes. - Proficiency in managing text data. - Ability to use Excel functions, including 'Find and Replace', 'Text to Columns', and 'Concatenate'. The primary task of the program would be to simplify, accelerate, and eliminate potential errors from repetitive manual work. It's crucial that the freelancer understands my data operations well to create a user-friendly solution that meets my needs. A detailed understanding of Excel and programming is vital for this project.

1. I do not provide you my AWS account . you develop all on your AWS account 2. Teach me ML python project end to end development on EC2 (not sagemaker) AWS w...response ) 4) Requests consists of data sample and unique Request ID. Machine learning model code receives data and Request ID. Then returns prediction and the same Request ID concatenated with date time of processing. Response: id and prediction and date time Many requests are sent asynchronously in batches or continuously. When predictions are received: unique ID returned from ML model ( concatenate to id time of predictions for example ID = abc34bnm then returned receipt at time 20240211164324 is abc34bnm_20240211164324 ) is used to match prediction and request Id to confirm it is the same request what was sent for ...

Please Sign Up or Login to see details.

I added a code snippet to add elements between paragraphs on blog posts, but somehow when this snippet is active it prevents youtube videos from being embedded. The job is to fix this bug. sample $parts = explode("</p>", $content); $count = count($parts); // call count() only once, it's faster for($i=0; $i<$count; $i++) { $output .= $parts[$i] ?? ''; $output .= '</p>'; $output .= $additions[$i] ?? ''; if ($i % 5 === 0) { $output .= '[products per_page="2" columns="2" orderby="rand" order="rand"]'; } // non-existent additions does not concatenate } return $output; } else { return $content; } } add_filter('...

...that consolidates various file types from a folder (xlsx, docx, docm, xlsm, pdf, outlook msg, txt, rtf, pptx, jpg, png, MS Office formats) into a sole, organized PDF. The resulting PDF should maintain the original order of the files in the source folder. Furthermore, this tool should also have the capability to extract and concatenate all attachments from outlook messages. Key features needed in the tool: • Merge files in their existing order. • Extract and concatenate all attached files. • Should skip any files that cannot be converted into a PDF format, such as executable files or certain types of media files. • Adapt the outlook .msg to portrait or landscape when creating its PDF equivalent. • Create a .pdf report with the file list (name and...

I'm looking for an excel expert to assist with a data concatenation project. My spreadsheet has text and numbers that need to be unified. Here's what you need to know: - Data Type: The da...Type: The data combines both text and numbers. - Location: The data to be concatenated is located in a specified custom range on my sheet, not limited to given columns. - Order: I want the concatenated data to be organized alphabetically. The ideal freelancer will have extensive experience with excel, particularly with text and numeric manipulation and sorting. They'll know how to effectively concatenate different data types within a specified custom range and sort the resulting data alphabetically. The ability to work promptly with accuracy is valued. If you have these skills, I...

I created a code snippet to insert random woocommerce products between paragraphs on all blog posts. Somehow there is a bug that creates 2 issues: 1. When the code snippet is active, youtube videos are not embedded anymore 2. The displayed woocommerce products are kinda messed up, check at... $content = get_the_content(); $output = ''; // define variable to avoid PHP warnings $parts = explode("</p>", $content); $count = count($parts); // call count() only once, it's faster for($i=0; $i<$count; $i++) { $output .= $parts[$i] ?? ''; $output .= '</p>'; $output .= $additions[$i] ?? ''; // non-existent additions does not concatenate } return $outpu...

...to parse. This needs to be fixed to handle. 2-currently it generates output for each input file. I need this to have option (checkbox) to put the output of all files in one output. Without duplicates (see #3 below). 3-this needs to add another column at the end that will write/append the file name that the row (which means the join condition came from). If it already exists, it needs to concatenate (comma separate) the file names. They need to be unique. Meaning, if i run the app on a file (input1) with no output, it creates and puts the filename in that column for the join criteria it adds. if i run the same file again, it will do nothing, because it exists and the filename is in the last column. If i copy the input file (call in input2 for example) and run it, it will ...

...Microsoft Excel Formula Expert who can modify an existing spreadsheet within 24 hours. The specific formulas and calculations needed for this project are VLOOKUP and IF statements. According to the sheet attached Result: Input(Colum A) paragraph will be added in the sheet; From Column B to P(Output) to be Processed with generic formula. (Output) Colum Q to have Heading also to be added when concatenate (Column I to column Q) Ideal Skills and Experience: - Proficient in Microsoft Excel and experienced in using VLOOKUP and IF statements - Strong understanding of data analysis and data manipulation - Attention to detail and accuracy in formula implementation - Ability to work efficiently and meet tight deadlines If you have the skills and experience required for this project, pl...

Expert knowledge of Excel Function Library, Working with Templates and Co-Authoring. Involving the following topics: Find and clear data validation settings. Set data validation with an error alert. Display the Developer tab on the Ribbon if it is not shown. Insert a spin button form control. Protect the worksheet for data entry. Remove the Developer tab. Create a nested function...with INDEX and MATCH to display inventory for a product. Use SUMIFS to calculate total pairs in stock by specific criteria. Use DAVERAGE to summarize customer survey data. Use DAVERAGE to summarize survey data. Create an IFS function. Calculate depreciation for an asset using a Financial function. Use CONCAT to build an email address. (If your version of Excel does not include CONCAT, use CONCATENA...

Title: Wordpress Website Designing and Developing Purpose: Concatenate of few websites Design: No, I am open to suggestions Features and Functionality: Yes, I have specific requirements Skills and Experience Needed: - Strong experience in Wordpress website design and development - Knowledge of e-commerce, blogging, and company portfolio website design - Ability to create a cohesive and user-friendly website by combining multiple websites - Expertise in customizing and implementing specific requirements and functionalities - Creative thinking and ability to suggest design and layout ideas to the client - Strong communication skills to understand and fulfill the client's specific requirements

I am looking for a freelancer who is advanced in Excel functions, specifically VLOOKUP, HLOOKUP, INDEX, and MATCH. Tasks and Responsibilities: - Assist with applying these functions to a specific project or task (to be determined) - Provide general assistance and guidance with these functions Skills and Experience: - Advanced level of familiarity with Excel functions - Strong understanding of VLOOKUP, HLOOKUP, INDEX, and MATCH functions - Ability to provide clear explanations and guidance on how to use these functions effectively If you have experience with these functions and are confident in your ability to assist, please submit your proposal. Thank you.

Hi Jitesh - For the Xero Invoice Concatenate task we just completed. Thankyou! :-)

...and w=(0, 3, -2, 12, 22, 0). Create matrix M from these vectors: 4 0 -5 3 12 -2 7 12 -4 22 2 0 b) Remove the second column from the matrix M and replace all elements on the main diagonal that are less than 5 with 3. c) Solve the system of equations Mx = b, where b consists of the first three elements of v. Round the solution vector to three decimal places and specify its average value. d) Concatenate the following two vectors so that they correctly display the names of the scientists: X = (“Lise”, “Marie”, “Rosalind”, “Ann”), Y = (“Franklin”, “Tsukamoto”, “Curie”, “Meitner”). e) Indicate all names and surnames from the previous task that contain the letter E/e or M/m. f) Create a l...

...we can decide on the size while working on it. - Popup content will have (3-5) inputs/radioboxes/checkboxes that we will decide while working on it. - on submit: 1) fetch latest N (configurable) posts from the {current post categories} 2) fetch latest N (configurable) posts from the {current post tags} 3) generate a concatenated string (call it "request") based on the inputs (3-5 of them) + concatenate all posts fetched in 1),2) + some default strings to help ChatGPT to generate a correct response 4) send the "request" to ChatGBT. The bots will return some results. - Show the result in the popup, in a textarea to allow user to edit. Buttons under the textarea: [copy] to allow user to copy textarea content; [Submit] to post the text as comment to current post....

I need the matrices to be downloaded and combined

...with the Google Search API, please review the following project requirements: You will be provided with a google doc spreadsheet with 5000 records Using the google doc API, you will read records out of this google spreadsheet Then Using the google search API developer stack You will concatenate the names of organizations into four separate search strings that you will query google with, using data out of the google spreadsheet google query string: "Organization name + Organization city + Organization state + keyword" There will be four keywords that google will be queried for, per record. Starting with 5000 records x 4 keywords, that will result in 20,000 google API search requests

Please Sign Up or Login to see details.

Please Sign Up or Login to see details.

I have a list of potential customers). - This list was converted from PDF to Excel ( Excel office 365) - so some of the orders are not correct. I need to refine couple of columns ( combining data using CONCATENATE or TEXTJOIN functions .. perhaps or something like that) - & make it ready for importing into Zoho CRM. Main task is getting the Excel formats correct ( Zoho task is secondary if you know Zoho that will be a bonus. But its not a must) -- Should be relatively easy task for someone who is good with Excel. I just want test this before giving other work.

The project requires to select a file and search the file for specific characters segments and extracting characters, placing these characters in a string and concatenate with keyboard strings and repeating this process until no more specific characters segments are in the file. When completed the final concatenate string will be used as variable for a Send to Keys command

What I could do in Oracle, MySQL, SQL Server I cannot do in Access Jet SQL: Concatenate. I just want to concatenate address fields in a report. It seems that I have to do all this IFF... null business: The first IIF is the only way to report all the combinations of Surname/, /Forenames, i.e. Surname only Surname, Forenames Forenames only The second to report mobile or landline if absent. I want to concatenate the 5 address fields and at best I get #Error datum and a handful of single fields out of the 5. SELECT IIF([Contacts & Preferences].[Surname] is null, IIF([Contacts & Preferences].[Forenames] is null, "", [Contacts & Preferences].[Forenames]), IIF([Contacts & Preferences].[Forenames] is null, [Contacts & Preferences].[...

Develop and maintain a robust Node.js server capable of handling two primary endpoints. Endpoint A: Implement a functionality that accepts video files and uploads them to an AWS S3 bucket. This endpoint should return a URL pointing to the uploaded video file. Endpoint B: Design a feature that receives multiple URLs of video files stored in AWS S3. Utilize the ffmpeg library to concatenate the videos into a single video file. The resulting video should then be uploaded back to AWS S3, and the endpoint should return the URL of the concatenated video. Endpoint C: Please start your application with the word CatMouse so that I can see you've read the instructions. This server must be deployed successfully, I'm open to suggestions on best services to host.

I'm looking for a freelancer who can help me with Autocad lisp programming. The task involves concatenating attribute values for a block with multiple attributes. The freelancer should have prior experience in Autocad programming and should be familiar with Lisp and compatible graphic programs. If you think you can deliver this project satisfactorily, please contact me and I'd like to hear your plan on how you'll go about completing it. Any questions or clarifications can be addressed at the same time. Thank you for your interest in this project! In same drawing there CAN BE MULTIPLE BLOCKS WITH SAME NAME and the data should be copied inside particular block. EXAMPLE: BLOCKNAME: BLOCK1 ATTRIBUTE1: ATTR1 ATTRIBUTE2: ATTR2 ATTRIBUTE3: ATTR3 Attribute values ATTR1, ATT...

On Nasa datasets apply PCA model then adasyn algorithm then The first layer is Bi-LSTM, the second layer is Bi-GRU, the third layer is LSTM, each node has 150 nodes, and the fourth layer is the attention layer for cross project software fault prediction and then calculate accuracy, precision, recall and f1score in python. i will be sharing 8 dataset file we have to concatenate them in the data set given in the promise folder given in GitHub code below (in which there are 11 dataset) .... .... this is the example model . we have to do in exact same way but using different models mentioned earlier

I need a Codeigniter developer to make changes to an existing project. To implement a new feature into the existing codebase. The project already has all the necessary code, so the d...of Base Currency amount 3) settings table should have Default Currency and it's value, give Currency in selected in attached image Attached `` This is Full view We want to copy this and display Account wise Total (e.g. Total Deposit, Total Withdraw, Total Received, Total Paid for selected Account) Debit in Red, Credit in Blue, Times New Roman font Display ID No. in Note column (Concatenate) In above all screen, wherever Delete facility comes, it should work correctly. We do Not want Edit facility in current milestone. Attached `` : 1) Remove `Site` drop down. 2) Add `User Id` textbox.

I have 10 tables with differents variables i need to keep only 5 variables on This tables But the name of the variable are différent between the 10 tables So i would like to use à mapping file which contains by table the name of the variable that i keep The output of This work is one table with 5 variables This table concatenate thes 10 tables inputs

I am looking for a freelancer who can assist me with creating a Screen Flow in Salesforce. I need help with the flow creation to concatenate 62 fields. I have 62 field that I need strung together into a very long text string. Ideal Skills and Experience: - Experience with Salesforce Flow - Strong knowledge of Salesforce and its features - Expertise in creating Screen Flows - Ability to automate business processes in Salesforce - Experience with data quality improvement and external system integration - Attention to detail and ability to work efficiently and accurately

...The project requires two back-end services coded in an open-source language and both must have REST endpoints. ## Requirements - Develop a stand-alone ReactJS component for the front-end interface - Three text input fields to accept URLs - A submit button - Develop two back-end services in an open-source language with REST endpoints: 1. URL content retrieval service - Retrieve and concatenate the 3 URL contents 2. ChatGPT API service - Receive the concatenated content from the first back-end service - Pass the concatenated content to the ChatGPT API service Deliver a full-service solution - Provide fully tested code that just works ## Deliverables 1. Source code for the ReactJS front-end component 2. Source code for the back-end URL content retrieval...

I need help resolving a syntax error in my JINJA2 code. I have a rough idea of what might be causing the issue, but I haven't yet pinpointed the source. I've been attempting to solve the problem for less than a day, with no luck. I'm looking for an experienced developer who can help me identify and solve the issue quickly. Thanks. I want to concatenate 2 JSONs and form a new one

...then send it out to W3W so they can send back the data? "lon": , This is generated from the w3w. Not sure how this can be generated within the CRM do they have a button feature so we can verify the w3w format then send it out to W3W so they can send back the data? "notes": , See below fields that are concatenated into the notes field from AT CONCATENATE("| Roof type:",{Roof Type}," | Roof covering:",{Roof covering}," | Duration Grouping:",{Duration Groups}, (This is created using logic in airtable not sure if this field is used and wanted in the team not sure of the CRM's formula fields capabilities to re create this) | Roof Loc link:",{Installation Map location Link} (This is created using logic in airt...

I am looking for a product driven developer with excellent communication skills with experience in building web based products and is quick to jump into existing codebase. We're looking for a developer who can research...to take Cloudwatch logs, run a simple transformation (simple regex replaces per log line) and push each line of log to an S3 bucket that corresponds with the customer. I would like to come up with the most scalable and cost effective architecture to perform this, discuss the various alternatives with us (pros, cons, etc) and implement this. Keep in mind that we would also like to be able to concatenate log files (instead of having a lot of tiny ones) and delete old files automatically, and that a future project would be to allow users to query these logs via a...

Hi experts, I need you to convert my jupyter notebook to a function (or new code) that runs n-times (or loops through a list) and concatenate all outputs as one dataframe. The attached code works well for Italian Serie A (league_code = 'I1'). I want to run through several league codes, eg: loop through the values in league_code = ['I1', E0', 'D1', 'P1', 'SP1', 'T1', 'F1',...] and concatenate results/output of each member of the league_code list. Final_output = (output_1,output_2,output_3,output_4,...,output_n

It requires VBA code knowledge to develop modules to eliminate repeative work and automate the task as per different Excel sheet data. I've almost designed the task framework just need modification with codes. Project minimise the routine task to arrange data to prepare measurement description as per standard. Basically it deals with concatenate, Column filter. Almost 70% completed but struggling with some modules. I've attached the files I've been working on. Title with project 1 has written with VBA modules on which we have to work for two different data Excel sheets.

Hi, we are looking for a solution where our customer could provide us a csv files online every day, we then have to process this file online automatically (e.g. arrange the content in a specific column structure and add some content in a concatenate cell) and then automatically store it somewhere via FTP. Is something like that possible? How would you do this and what for a technical environment we would have to provide for you? Thank you for your suggestions and best regards, Michael

I need someone to concatenate separate tables, contained in both separate tabs in Excel and in separate Excel sheets, into one combined Excel database consisting of 6 concatenated sub-databases, grouped by category.

I'm looking for someone to set up a set of template excel files to set up draft ...start price, shipping cost, etc.) • other fields which will vary based on the individual item being sold (ie: item description, custom label/locator, etc.) Ideally, I'd like a set of excel templates which can be easily filled out by someone not very technical, but will automate population of information in a CSV which can then be uploaded to eBay to create the draft listing. Things like: • concatenate multiple fields to make up the listing title • a dropdown of pre-determined categories (also need to be able to enter a custom category or add to the list) Basically the excel sheet needs to be as dummy-proof as possible so that someone who is extremely non-technical is able t...

Please Sign Up or Login to see details.

Android app Scan barcode, concatenate barcode with temp save that. Invoke camera take image, return to app Rename image with the filename from barcode Upload image to FTP folder Delete local image after successful transmission

I think this should be an easy request for a Excel guru, but I am not that. I need a formula that I can apply to every cell in a column that will concatenate values from multiple columns with an if condition. If the values are the same in another column then concatenate the value. I will upload a sample file of what I am looking for. I will try to describe the logic base on the file. The spreadsheet has a list of tests with Test IDs and Test Names. There is a column for the Location ID that the available test id/test name need to concatenate with ";" as a separator and fill the cell. This way all available tests for that location will be in one cell with a ";" separated between them. I need to be able to apply the formula to a file with 20,000 tests...

Looking to have a web scraping app built as a chrome extension 1) user turns on extension 2) app runs and monitors web traffic and responses (like using Inspector shows for network/XH...as a chrome extension 1) user turns on extension 2) app runs and monitors web traffic and responses (like using Inspector shows for network/XHR) in user’s in focus tab 3) app automatically saves network request responses as user browses to user’s local machine (download folders) 4) if response is JSON. Convert Json to csv file and save. 5) if format of multiple requests is the same for Json, concatenate multiple responses into single CSV 6) user clicks Stop to end the capture and save files locally. I will require source code and will look to publish as a free extension in the chrome a...

Please Sign Up or Login to see details.