Rows työt

create new columns with N characters after string pattern needed MS SQL server REGEX specialist **** prove you can do it, give me example complicated SQL query for text search using regular expressions you coded in past **** also you need to create small DB with at least 20 rows to prove it works it should be optimized for calculation speed like but pattern not exactly known for example "good big food" or " good big food" - spaces " good big food" " good big food " or " good bg fod" letter missed or " good biag fohod" letter inserted at least when many random spaces added for "car plane asdfaf fa asdf good big food : abc table asdfasdf

I need a Excel expert to arrange the data in appropriate columns and rows.

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I need a print macro that will automatically fill the template page ( supplied ) and print the records on the data tab. There could be up to 5,000 records. I will nee...records on the data tab. There could be up to 5,000 records. I will need an option to start printing on a particular row in data sheet If the remaining records on the last print page are less then 32 , it should just be able to print with null records on remainder of sheet. I'll provide data in spreadsheet to test your macro for this condition. The macro should automatically index to the next rows after the page is printed. With the screen shots of the spreadsheet you get what the idea is for each label I use a $ in the first column to signify the end of the data Would like to have it done today or e...

...maintained in various excel files. An application is required where user can maintain each excel template based on which table structure to be created. An interface required where user can maintain the various data validations rules / constraints for each field for each template. On an ongoing basis, user is required to import data from the excel template which will involve new rows addition /update on existing rows. Application will validate the data in excel file as per the data validation rules maintained for the particular template and import only those records which meet the rules. Others to be updated in a log file with reason for rejections. Interface required where user can maintain Report formats for each Excel template. That should be presented with the list of f...

Hello, I have the following in detail by transaction ie. purcahse invoice/date, sales invoice/date, product code, quantity, returns, inventory transfers, registrations and write off's as ...importantly, filter to see greater or equal to an custom "x" value entered. The report should include both detailed analytical google sheet, but also infographics demonsting the risks and high value, long un sold dead stock value in red etc. filters mentioned above are applicable. Please share prior experience in a complex environment where the product database is above 100k rows and transactions are above 80k rows of sales, purchase, transfers, registrations and write-off's. Please share as well a cost/budget proposal for the same and expected delivery date no later...

Hello i tryed to do migration with cart2cart and litextension company, fully assisted and both get issues, that migration failed, from database to prestashop, comes without option for products that have more options, because on magento 2 was installed a module mageworx that including all options of product. We need someone that do migration perfect, we need migrate only 11.000 product...and both get issues, that migration failed, from database to prestashop, comes without option for products that have more options, because on magento 2 was installed a module mageworx that including all options of product. We need someone that do migration perfect, we need migrate only 11.000 products, options, images, and category of products. On database is visibile the options, under mageworx rows...

...like this: =VLOOKUP(unique_identifier, source_range, column_number, [exact_match]) Replace "unique_identifier" with a reference to the cell containing the unique identifier for the client in the destination document (e.g. A2 for the first client). Replace "source_range" with the range of cells in the source document that contains the client information (e.g. 'Sheet1'!A2:C500 for the first 500 rows in the source document). Replace "column_number" with the number of the column in the source range that contains the email addresses (e.g. 3 for the third column). Set "exact_match" to TRUE if you want the VLOOKUP formula to only return a result if there is an exact match for the unique identifier, or FALSE if you want it to return ...

MVC ASP.Net project. I want to add one feature in the index page. After selecting rows I want one button wich will open modal partial page to write an e-mail and send it to the selected user.

...the booking of musicians. The process would work like this: - Enter company and project info at top - Enter the number of players needed for each section (Strings, Woodwinds, Brass, Other) and the total number of hours they are needed for. I don't want to show instruments not being hired, right now I need to delete all rows not in use. - Autofill from the roster of players are the far right for each instrument (in the order they appear in the list) - do not show any empty rows in column O. - The part I don't know, can we email the musicians in column O with the session dates and times with Gmail and LOG their responses in Google Sheets? Marking confirmed musicians and green and removing the the musicians who decline to a column (AG) and emailing the next musician...

I need data sorted of our client list of more than 7400, many emails phone numbers address are in wrong fields. IN addtion I need City State and Zipcode seperated. Also seperate column for international I have an example of the data that I can send to you of how I want It vs what it is. The green higlighted rows are the correct format and the yellow highlights show how they need to be displayed. The data below that is how it will be coming to you

...winning a race over others. I would like to establish the probability of a horse winning a particular race using the data I have access to. I understand from others who use horse racing data that a Bayesian approach usually works best, given the nature of the events can change over time. I have raw csv data going back to 2016, a sample of which is attached. The raw data contains approx 1 million rows and over 150 columns. Each row is unique to an individual horse in a particular race. The data is a mix of numerical and non-numerical data, which can be tested against previous results. An outline of the project is attached with a more detailed explanation of the various columns available on request. Deliverables 1) The overall objective is to find a probability of the FIN ...

READ ALL OF THE PROJECT DETAILS The MAXIMUM pay for this project is $15 We have an Excel Sheet that contains 1603 rows/records. Out of 1603 rows/records we have to delete 511 rows/records. We have a list of numbers for the rows that need to be removed from the excel sheet. For example row 2, 6,11,19, 45, 68 etc. The list of rows numbering is the default excel sheet row numbering at the left most side. TASK: We are looking for an automatic way in Excel based on which we can delete the required 511 rows at the same time. We are looking for an Automatic method where we add copy and paste the required rows numbering and they will get deleted automatically. Note: Our Data is not based on Values and Ranges and we know all Formulas that select the ...

Looking for a script to be built that takes a csv containing a list of instagram usernames and is able to provide a count of followers for each username. The output would be a csv with rows containing username, count pairs

READ ALL OF THE PROJECT DETAILS The MAXIMUM pay for this project is $15 We have an Excel Sheet that contains 1603 rows/records. Out of 1603 rows/records we have to delete 511 rows/records. We have a list of numbers for the rows that need to be removed from the excel sheet. For example row 2, 6,11,19, 45, 68 etc. The list of rows numbering is the default excel sheet row numbering at the left most side. TASK: We are looking for an automatic way in Excel based on which we can delete the required 511 rows at the same time. We are looking for an Automatic method where we add copy and paste the required rows numbering and they will get deleted automatically. Note: Our Data is not based on Values and Ranges and we know all Formulas that selec...

I'll give you First Name and First Initial of Last Name, brokerage, City, and State You can go to or or another other website to find the rest of the information Total: 8,000 rows NEEDED FIELDS: Last_Name License Phone Email Address About Website Experience Area Served Twitter Linkedin Instagram Facebook Youtube Profile Photo URL

We are using the VROOM Project front end for a proof of concept within our project. The code is open source You can demo it here - We are looking for a few enhancements to this: - Add ...looking for a few enhancements to this: - Add a loading icon when calculating the routes (it can take 5-10 seconds) - Add a color key next to the Vehicle name to show which route corresponds to which user - Create a download/export button that produces a CSV or XLSX of with columns for the Assigned Vehicle (description field) and Job (description field) - (obviously with the route output contained as rows in the file). Start your proposal with your favorite fruit to show you've read this. Changes will have to be submitted via git.

Hi, We have 36 (9 rows and 4 columns of each row) High-Resolution images to be created for Ferriman Gallwey from scratch. Need it in 72 hours. Require High-Resolution PNG and Vector files for the same. Images must mirror actual body parts. Scientific details of what each image is about is given here. Also

MVC ASP.Net project. I want to make update to multiselect number of requests and apply two differen function. Eaither change the status or send an e-mail to the user.

We are using the VROOM Project front end for a proof of concept within our project. You can demo it here - We are looking for a few enhancements to this: - Add a loading icon when ca...looking for a few enhancements to this: - Add a loading icon when calculating the routes (it can take 5-10 seconds) - Add a color key next to the Vehicle name to show which route corresponds to which user - Create a download/export button that produces a CSV or XLSX of with columns for the Assigned Vehicle (description field) and Job (description field) - (obviously with the route output contained as rows in the file). Start your proposal with your favorite fruit to show you've read this. Changes will have to be submitted via git.

The task is to enter information about music albums from web pages to google spreadsheet. Looking for someone to work with long term, preferably with good English and an advantage for people who like music. Will pay fix price for bulks of 10 complete rows. Instructions in the following documents:

hi i need a menu copied into an excel sheet (csv) ill provide the excel sheet with a few rows filled in come fast will have more work in future for right candidate

2 columns each with a Specific date in sequence totaling 9 rows ( 1 year ) “this part is completed” but can be reworked to be more elegant or improved upon Another 3 columns for results also totaling 9 rows the results being 0-16 but the total of the three cells in each row can not exceed 28

hi i need a menu copied into an excel sheet (csv) ill provide the excel sheet with a few rows filled in come fast will have more work in future for right candidate

The task is about 1) Updating rows and deleting rows in ninja form. 2) Add fields in Only request this job, if you know basic php and "Interacting with the Submissions Model" in ninja forms.

I have a script to collect api data that is being limited by the server (response 429 too many requests) I think I need the script to run through a proxy server to avoid the limit but I have never done this before. Script works but times out. So I need someone to help me setup a proxy server so I collect data. 8 million rows of data. Maybe 5 GB of data

I have a table of subreddits with assigned tags. I have another table of content photos/gifs, I want to be able to put tags next to those content and subreddits to be populated based on that ( this part is already done). after that I need rows in another table to be created , scheduling these posts. so there will be a content itself, subbredit which was assigned to it in previous table and the date when it will be posted. the date needs to have a condition because one reddit account can usually make one post in one subbredit so each content can be scheduled once in a day in the same subreddit. So for example, if I want to post 2 different photos in r/news subreddit, schedule table should assign different dates to each photo mention Ambawe so I know you've read the project

We are using the VROOM Project front end for a proof of concept within our project. You can demo it here - We are looking for a few enhancements to this: - Add a loading icon when calculating the routes (it can take 5-10 seconds) - Add a color key next to the Vehicle name to show which route correspond...for a few enhancements to this: - Add a loading icon when calculating the routes (it can take 5-10 seconds) - Add a color key next to the Vehicle name to show which route corresponds to which user - Create a download/export button that produces a CSV or XLSX of with columns for the Assigned Vehicle (description field) and Job (description field) - (obviously with the route output contained as rows in the file).

There is an Excel sheet of data with 20000 rows. There will be set of questions provided. The candidate is expected to perform queries and tableau visualization on same

...the data is stored in a different object, (you'll see three objects at the top of the hierarchy). So this won't go through any existing parser, it will probably need to be decoded programatically. In simple terms read through a series of nested arrays, in the first data object, look up supplementary data from a set of arrays in the third data object, (matched by a unique ID) and output as a rows in Excel. First worksheet - I've tried to walk through the logic required in the attached Excel, you'll see a reference to the JSON with examples and psuedo code to the right referencing how to create the Excel output from that example. Second worksheet gives you an idea what the finished file will look. Presenting sporting event data. I'd love...

Hi Md Rashed K., I noticed your profile and would like to offer you a small project to see how you work. We have a report where data (product description) is spread over multiple rows. We need the product description in one cell and then we need to automate for future spreadsheets

This is a very simple data set that is being generated from a system in a format where the data is not aligned with headers, and the data is split across two rows. The challenge is to come up with the fastest solution in excel or power bi to reformat this type of data into a useable dataset as this is a process that will need to be repeated many times over. Please upload the data set reformated, and instructions for how you acheived this efficiently. The raw data is attached, and the required output is in the Power BI contest file. Any quesions, please let me know. Good luck!

I need to return multiple row from excel...an other excel file. I have two excel file, "" is the source of data, while is the destination. The data (rows) that will be transferred to Book1 is only that rows for which the text in cell "S2" in Book1 matches the column () in Book2, while the rest of the rows is ignored. When all rows matching the criteria has been transferred, any blank cells (cells with no text) should replaced with the word "Undefined". I don't want to use a macro for this project, my Office version is MS office pro plus 2016, the texts will be bilingual (Arabic and English). I'll pay ONLY $15 for this project, no more. Rows in Book1 must be consecutive with no blank rows in between. In last ...

Hi..this is bit manual task... 1) I have "addresses" and/or "apartment names" in 1 column which are partially incomplete, misspelled or jumbled up. 2) One needs to search for these details (address, apartment name) in Google maps or search bar and paste the right info against each of this cells there are ~6000 rows aprox I'm enclosing the file for reference (refer 1st sheet)

I need to return multiple row from excel...an other excel file. I have two excel file, "" is the source of data, while is the destination. The data (rows) that will be transferred to Book1 is only that rows for which the text in cell "S2" in Book1 matches the column () in Book2, while the rest of the rows is ignored. When all rows matching the criteria has been transferred, any blank cells (cells with no text) should replaced with the word "Undefined". I don't want to use a macro for this project, my Office version is MS office pro plus 2016, the texts will be bilingual (Arabic and English). I'll pay ONLY $15 for this project, no more. Rows in Book1 must be consecutive with no blank rows in between. In last ...

-Remove rows that aren't product -Re-translate the words in English column if needed -Remove words such as price, city name, brand from English column.

Hi, I have data including the number of columns and rows. I have the code which makes min and max as I need. the thing missing is to split the result to make the all minimum in one excel sheet, the maximum in another sheet and the final sheet has min and max and average.

I have a data analysis project that I want to publish. However, I can perform all the analyses, the code I created is messy and hard to understand to others. I want to make my code easily understandable and clean. The code is no longer than 150 rows with many options for shortening.

Running WordPress site with the Ninja Forms plugin. This form uses a repeater row where you can add or remove rows as needed. Within each row there are different measurements required to input. In a different field, I want it to select a size based on the input of the measurements.

Eead all before you bid. Budget is not set. Freelancer will be selected based to time needed for thus task and how much funds are needed so bud accordingly. Freelancer is to make excell file from zerro and gather all needed statusticak data. Data shoukd be real, up. Needed are simple statistical data in excell file (.xls): Rows let them be incremented integers 1,2,3,4.... Columns: 1) Country name (list all countries in the world and proper capital typing, not all capital letters) 2) number of people living in that country 3) percentage of men 4) percentage of women 5) name of website domain name extension (Slovenia has "SI", Italy "IT", Croatia "HR") 6) percentage it represents of whole population 7) currency (Slovenia "Euro", Philipines &q...

You have to count specific words in the text and then write under columns made for them (7 lists of words on sheet 2 and tell them in separate columns on sheet 1). You are already provided with columns....so, the project should not take more than few hours. You should provide a sample for 50 rows to get a project and also we should be able to see a formula in the formula bar.

We are creating a mailing list for our clients xmas cards and the exported Adress is in a single cell and needs to be in 4 cells separated by Adress, City, Province, Postal Code. The first 9 rows are complete. I hope you can write a formula for this and be done in seconds. :) otherwise its manual entries.

...record that is loaded into the table. SQL Server Name – Server where the data will be stored SQL DB Name – SQL Database name where the data will be stored. SQL Table Name - SQL Table where the data will be entered from the excel file. InsertType - (All at once), (1000 records per transaction), (1 row at a time) LogErrorstoFile - (True), (False) It should skip rows with errors, and in the end in the results it should show which rows were skipped and which columns caused the error, or what the error was. Error should log to a file, if LogErrorsToFile is enabled. A demo class type will be provided to give you an idea of how I want this class information setup and what it should look like. ...

Hi just want to get a price on having a manufacture carousel raver than the manufacture logos going onto two rows

...Notation For the description of the game situation and moves we use a modified FEN notation (known from chess). That is, the columns are labeled with small letters from a to i, the rows with numbers from 1 to 9. To determine a field unambiguously, the column is always indicated first and then the row. Here a1 denotes the lower left corner, i9 the upper right. At the beginning, the black figures are on the " bottom " squares in rows 1-3, the white ones on the " top " ones in rows 7-9. Game board The game board is described by a string, which is constructed as follows: rows are separated by "/", and within the rows the squares are separated by ",". There is no "/" at the beginning and end of th...

...Notation For the description of the game situation and moves we use a modified FEN notation (known from chess). That is, the columns are labeled with small letters from a to i, the rows with numbers from 1 to 9. To determine a field unambiguously, the column is always indicated first and then the row. Here a1 denotes the lower left corner, i9 the upper right. At the beginning, the black figures are on the " bottom " squares in rows 1-3, the white ones on the " top " ones in rows 7-9. Game board The game board is described by a string, which is constructed as follows: rows are separated by "/", and within the rows the squares are separated by ",". There is no "/" at the beginning and end of th...

I have data from 2 tables with 6 rows and 2 columns each. I need a chart #1 created from the data in the first table with labels on the chart and chart #2 data created from 2nd table. I then need a PowerPoint displaying the data in chart format comparing and correlating the two, an analysis slide, and a 3rd blank slide I can use to add an action plan. I need this today, please.

...player evaluation for large basketball events (100 teams). The app or platform must be able to be used without an internet connection or at least be able to save information without internet Information will be imported from exposure basketball. The information will include player name, team name, grade, position as well as other miscellaneous information. Will need to have capabilities of 1000 rows 6-8 columns. Page 1 of app should have all Big Time Hoops events available to choose. Once you select the event, the team list should pop up. After you pick the team name, the players from the team pop us. After you select the player any information will transfer over from previous events. We want to have the option to view previous evaluations and compare and contrast to see if pl...

we have a flutter app that is hosted by wordpress backend, but as data growing, some tables even grow to 10 millions of rows and caused performance issue. so we would like to optimize wordpress database structure to improve performance.

Medical Error Prevention CE course: English to Spa...Deliverables: English to Spanish translation of Medical Error Prevention Continuing Education Course - lecture and test questionnaire. (6) Deliverables format: Use a Word file for this project. Present translation in table format. 2 columns. Use the left column for the English version. Right column for the Spanish version. Attach each title, subtitle, paragraph, and question into rows. Affix Spanish translation to corresponding rows. See attachment for sample format and other details. (7) Any possible revisions are to be submitted within 2-3 working days upon notice/advice. (8) Notice: Please do not disclose any part of this project details/description, including particulars and deliverables, to third parties unless dire...