Sql query to find and replace text in a column jobs

I need an OpenAI to Telegram ChatBot create. The ChatBot needs to be able to find, read and analyse real time data online when chatting

I'm in need of a skilled individual to perform online data entry and cleaning tasks. The project involves: - Entering text data from online sources like websites and databases - Cleaning the data before entry to enhance its quality and accuracy Ideal candidates should be detail-oriented, proficient in data entry and have a good understanding of data cleaning processes. Experience in managing text data is a plus.

I'm in need of a skilled developer who is experienced with inventory management systems, report production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: - Inventory management: Ensuring that the software effectively tracks the inventory of returned products - Reporting & Analytics: Enhancing the software's capability to generate insightful reports about warranty returns. - User access control: Improving the control measures for different user permissions within the software. - Ticket creation, Data Import and Export: Aptitude in handling these features are considered a plus. The overriding purpose...

...Freelancer.com We are an established employer. Quick and correct work will earn you positive feedback and timely payment. ************************************************************************************************** Project description : I want the details of 200 companies and their CEO's with very specific criteria. This is an intensive, manual work project that will take at least 4 hours of dedicated effort of searching through Linkedin / Google/ general web search. Please proceed with reading further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be sourced from databases such as Apollo.io. Please do not waste your valuable t...

Please Sign Up or Login to see details.

...require a proficient developer with detail knowledge of the Google Calendar's API as a consultant to help us resolve issues with adding attendees to events and having the events show on the customer's calendars. Key Issues: - Replace Google's standard email to Customer about adding the event to their calendar with our own customized template. - Help us understand different approaches to synchronization to customer events - Best approaches to handling recurring events that have multiple days, different times on different days, and numerous exceptions Ideal Skills and Experience: - Extensive experience with the Google Calendar API. - Strong understanding of event creation and...

Building a comprehensive school management software with features like online exams, results management, fee management, and more would require integrating various modules. Here's an outline of how you could structure such a software: User Authentication and Access Control: Allow administrators, teachers, students, and parents to log in with different levels of access. Student Information System (SIS): Store and manage student demographics, academic records, attendance, health information, and conduct records. Teacher/Staff Management: Manage teacher and staff profiles, attendance, timetables, and leave requests. Online Exam Module: Create and manage online exams with customizable parameters (e.g....

I'm in China now, and i can work as Online Chinese tutor or Android Developer, right now i work for a Canada Company as a translator, but these are part time jobs, and i want you to find job for me, and you can get 10% of the salary i get if you find the job for me. I can give you my resume

I have a set of handwritten documents that need to be transcribed into a digital format. The data is purely text-based and is to be entered into a PDF file. Key Requirements: - Accurate and efficient transcription of handwritten text - Creation of a well-formatted PDF document Ideal Skills: - Proficiency in data entry - Strong attention to detail - Familiarity with PDF file creation Experience: - Prior experience with handwritten text entry - Past work with PDF file generation Looking forward to receiving bids from freelancers with the appropriate skills and experience.

Current project is built on Laravel for both front and backend. Need to build React frontend to replace Laravel frontend side. All the pages inside current pages should be moved to React with new template UI and all same functionalities. Main Laravel frontend back end Login this saas/superadmin version (include All modules) USE THIS Admin TEMPLATE FOR Frontend Current system making this stacks - Laravel, MySQL, VueJS, JQuery & Bootstrap, DOCUMENTATION API DOC

I need an experienced and detail-oriented freelancer to edit a PDF document. The changes required are strictly related to content, not formatting. I will share a note with you and you need to put in the PDF. Ideal Skills: - Prior experience in PDF editing. - Proficiency in English to handle text edits. - Attention to detail to ensure all changes are made accurately.

I am in need of an experienced graphic designer to create product packaging labels for my medical items. These labels will be for medium-sized packaging, and they do not need to be waterproof. Key Requirements: - Create visually appealing and professional product packaging labels - Prior experience in designing product labels, especially for medical items, is a plus - Ability to deliver high-quality, print-ready designs in a timely manner - Understanding of SFDA regulations for medical product labels is preferred - Experience with medium-sized packaging is important The ideal freelancer for this project should have a strong portfolio of label design work and should be able to demonstrate their und...

Need to convert text file to a clean page and remove the colums showing passwords.

We need to find Uzbek to ENglish US linguists. We need translators and QA. volume is 1500k words. payout is 0.02Usd per word !. We need experienced linguists only. everyone who wants to work must have to pass a test. Payment is monthly Send me your per hour rates. in my job post payout is 5$ fixed . but its just for hiring. when we get feedback i will pay you 0.02$ each qualified word. feedback will come in 30 days. Thank you!

...searching for a seasoned professional with expertise in cold calling, Facebook messaging, and sales, to help us find leads and pitch our web development services to service providers. Key Responsibilities: - Conduct cold calls, Facebook messaging, and emails to generate leads and convert them into appointments for a sales team. - Draft and deliver compelling sales pitches that highlight the benefits and value of our web development services, with the aim of securing appointments with interested service providers. - Collaborate with our sales team to ensure that all appointments are well-documented and followed up on. Ideal Candidate: - Proficient in cold calling, Facebook m...

...for a skilled designer to create a modern and minimalist text-based logo. The logo should be designed in black and white color scheme. LOGO NAME: Dayasha Key Points: - Text-Based: The core of this project is the text element of the logo. The design should be creative and engaging, but primarily focused on the text. - Style: The desired style for this logo is modern and minimalist. Please ensure that the design reflects these characteristics. - Color Scheme: The primary colors for the logo should be black and white. The design should be able to stand out and be recognizable even without the use of colors. Ideal Skills & Experience: - Strong background in graphic design ...

You will need to visit and search for the following categories. Drainage Glazing repair Appliance repair Plumber Electrician Roofer Use the postcode W2 4DP After you have the search results You will need to open a google sheet and have the following categories Name of Business Website (you will need to find this either from checkatrade or google if you use google do not put LTD on the end) Companies house link for each business use this link The task is to complete 500 companies - please bid knowing this and only bid if you read the brief and understand it

I'm looking for a skilled professional to assist me with transcribing handwritten notes into plain text. Key Requirements: - Efficiently transcribe handwritten notes into plain text format. - Pay attention to detail and ensure accuracy. Ideal Skills: - Proficient in English. - Strong data entry and transcription skills. - Experience working with handwritten documents.

I have a STEP file of a PCB that includes submodels of various components. Each submodel is named by the component, e.g., resistor 0402. I need someone experienced to identify and accurately place components (e.g., resistors) in the STEP file. Attention to detail and precision are crucial for this job. Start comment with fustion3

I need a hand with entering a small amount of text and numbers data into a spreadsheet. Key Requirements: - The task involves a small amount of both text and numbers data entry. - The specific software to be used has not been specified by me, so you can work with what you're most comfortable with. Ideal Freelancer: - Proficient in data entry, with experience handling similar tasks. - Familiarity with popular data entry software, like Microsoft Excel and Google Sheets would be beneficial.

I have a project that requires entering textual data into a plain text format. The data will be sourced from various online sources. Key Requirements: - Textual Data Entry: The task is to precisely gather, copy, and paste textual data from online sources into a plain text format. Ideal Skills: - Fast and Accurate Typing: To ensure efficient data entry. - Attention to Detail: To maintain accuracy in the data entry process. - Internet Research: Ability to navigate and gather data from online sources. Experience with similar projects and positive feedback will be a plus. Please bid with your relevant experience.

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

...experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from ...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different ...

I need a simple, single-column WordPress site set up with the following requirements: - The site will need to be built from a provided WP demo content folder, including plugins and theme. - The main content will be of a standard, text and image-based nature. - The site design should be a straightforward single column layout. For this project, you would need: - Proficient skills in WordPress - Experience with SCSS - The ability to set up a local site - Familiarity with migrating WordPress sites Please ensure you can work with the provided WP demo content folder as the basis for the site.

...assistance with a specific task related to Excel. This task involves the careful extraction of data from Excel into a pivot table. The data in question is financial in nature, and more specifically, the focus is on expenses. Here is what I require: - Just the expenses data extracted from the Excel file and made available for the creation of a pivot table. - You'll need to determine the format of the data in the Expenses column. Your skills and experience: - Advanced knowledge of Microsoft Excel, especially in working with different types of data. - Proven experience in handling financial data, specifically expenses. - Ability to interpret varying formats of data on Excel. - G...

Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This process will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR....

I'm in need of an expert in VB.Net webforms to create an HR job portal for me. The portal should incorporate the following features: - I also want learn this - A job search and filtering module, allowing job seekers to find suitable positions. - An option for resume submission, where job seekers can upload their CVs for potential employers to view. - A company profile section to provide a brief about various potential employers. Within the platform, we'll have two distinct roles: job seekers and an admin role. The admin should have extended access and capabilities to manage all activities on the portal. The layout and design should resonate with a professional an...

I am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS

I'm in need of someone who can help me with lead generation. I'm looking to target specific industries in the process and would like to focus on the following segments: - Manufacturing & Machine Industry - Energy Providers - Insurances - Webshops ALL COMPANIES MUST BE BASED IN THE COUNTRY OF SWITZERLAND. COMPANIES SHOULD BE OF SMALLER TO MEDIUM SIZE, IDEALLY BETWEEN 10-99 EMPLOYEES. The leads I'm interested in should be responsible for digital transformation, digitisation, or be a product manager/owner. In small companies, this might be the company owner/CEO. In a bit larger companies (e.g.> 50 employees), this could be a separate position, which could either have the title o...

I need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.

I have a bulk of digital files that need to be accurately transcribed into a digital format. The files are all in English, so proficiency in English is necessary for this project. Ideal skills and experience include: - Proficient in English - Fast and accurate typing skills - Experience with data entry

I'm in need of a freelancer who can help me find new clients for my web development services. Key Tasks: - Generate leads and bring in new clients - Identify and engage with potential customers interested in web development - Maintain and grow our client network Ideal Skills: - Proven track record in client acquisition - Strong understanding of the web development industry - Good communication and relationship-building skills Experience in sales, marketing or a related field is a plus. The ability to leverage existing networks and create new ones will be highly regarded. Please apply if you're confident in your ability to attract clients and help gr...

I'm in need of a freelancer who can make a simple but crucial update to my logo. - The current logo features 'Text A', which I need to be replaced with 'Text D'. - It's a straightforward job, and I would hope it can be completed within two minutes. - The updated logo should be saved in PNG format. Ideal Skills and Experience: - Proficiency in graphic design, specifically with logo editing. - Experience with a variety of file formats, particularly PNG. - An eye for detail and the ability to follow instructions clearly.

I'm planning to venture into the dropshipping domain, with a specific focus on portable dog water bottles. The idea came about, but I'm uncertain if it's feasible. I have conducted some market research, but I'll benefit from a professional's eye. I am targeting pet owners with an active lifestyle who would find these bottles useful for their companions. I am looking for someone with: - Prior experience in marketing dropship products - Knowledge about the pet supplies market - Excellent market analysis capabilities - Innovative marketing strategies to target pet owners and individuals leading active lifestyles Your main responsibilities would include: - Evaluating the feasibility of my product idea - Robust market...

I'm lo...looking for a data entry professional who can handle digital text data entry. - Data Entry: The primary task will be to transcribe and input text data from digital files into a database. This requires exceptional attention to detail to ensure accuracy in transcription. - Data Analysis: Beyond simple data entry, I'm also seeking someone who can perform basic data analysis on the entered text data. This includes checking for patterns or trends within the data, as well as ensuring the data is organized in a manner that facilitates further analysis. Ideal Skills: - Proficient in data entry and management - Strong attention to detail - Basic data analysis capabilities -...

Please make wordpress site as atteched image. 1 column and respoinsive design.※If possible,bootstrap design. Anything is include dummy text and dummy images. I make inquiry and faq,sitemap page by myself and send you wordpress login details. Required Pages:Top page,fx,crypto-ex page,1 currency detail page Please make within $120(absolute requirement) and delivery within about 2 weeks and give me a progress report every about 4 days. I think only the table part is a little more challenging.

I've attached two drawings which is what I would like professionally replicated so I can eventually print across say 3 x A3 sheets and display on an easel. I have attached a photo of what the old building looks like which is what one of these two drawings will replace.

[NO AUTO GENERATED APPLICATIONS… WILL BE DELETED] I need someone familiar with affiliate marketing programs and sites. Someone that can find me some good affiliate products for me to ask. Tell me some good affiliate products into Instagram. You will search programs like Clickbank, Amazon, etc. In your application tell me about some products that you have found for clients. Have you ever sold affiliate products through Instagram?

I have a high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the ne...

I need a custom custom GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capa...

I need a skilled Photoshop expert to transform the drizzle in a photo to a sauce. The edited photo should look as realistic as possible. Here are the key points: - Replace Drizzle with Sauce: The main task is to replace the drizzle in the original photo with a sauce(the organge color). The sauce should blend seamlessly with the rest of the image, making it hard to discern the editing. The end result should look as if it was the original intention of the photo. - Realism: The level of editing required in this project is photo-realistic. The sauce should not only look like a sauce but should also appear as if it belongs in the original image. - Attention to Detail: I am looking ...

I am currently in a position where I want to have full control over my money. I am intending to dissolve my trust fund for this reason. This is an important step for me and I require professional input to guide me through this process. I am searching for someone with a strong background in financial management, particularly in trust funds. Knowledge in investment tracking is essential, alongside the capability of providing me a system where I can manage, monitor and make decisions about my finances independently. Additionally, the right candidate will be someone capable of: - Guiding me through the dissolution of my trust fund - Helping me establish full control and decision-making authority over...

I'm in need of a detail-oriented freelancer to carry out a text data entry project. The task requires entering text data into PDF files. The volume of entries isn’t yet determined, so flexibility and capacity to handle potentially large amounts of data is key. Ideal Skills: - The ability to enter data accurately and efficiently - Familiarity with PDF files - Excellent attention to detail Experience: - Previous experience in data entry projects - Experience working with PDF files would be highly advantageous.

Find Project Description here - Upon completion, push the code to a public repository and post the link here

Our existing CGI...encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting d...

I am on the seek for a talented Photoshop artist with experience in movie poster design and photo manipulation. Your task is to incorporate my image as a main character, specifically replacing Vito Corleone, on The Godfather movie poster. Ideal Skillset: - Strong command on Photoshop and photo editing. - Understanding of movie poster aesthetics and design. - Experience with image manipulation on pre-existing artwork. - Fan of The Godfather series - a plus. Project Specifics: - You are to replace Vito Corleone's face with mine. - Photo realism and seamless integration into the artwork is essential. - The final image should adequately capture the intensity and style integral to 'The Godf...

I search anharmonic indicators that can find custom harmonics, i've also find one that its okay and i have collected interesting information on non-traditional harmonics: they have an impressive win rate! The indicator name is Custom XABCD Validation and Backtesting Tool (open source), but for the purpose of completing the search, it would be useful for me to be able to insert multiple values within the same field, for example in AB/XA I could enter multiple values at the same time (5/6), as well as in BC/AC, and so on, in so that the indicator is activated as soon as a combination of those values matches. having already a code base, I believe that for a pinescript developer it is a piece...