Find Jobs
Hire Freelancers

Truncate Company Name Field based on characters and spacing

$10-30 USD

Completed
Posted almost 9 years ago

$10-30 USD

Paid on delivery
Need a simple quick project done. I have a table with a column [Company] with 2500 records. I want to make a temp table with all of the 2500 companies with another field called [CoShort] with a truncated version of their name with the following rules in order. IF 1. ) the company name has 3 or more words in the name I want the first 3 letters of each 3 words for 9 total characters. ex: Steve's Ice Cream and Donuts = STEICECRE Fishing and Tackle Suppliers Inc. = FISANDSUP 3M Tape Company = 3MTAPCOM ELSE IF 2.) the company name only has 2 words in the name I want the first 4 letters from both words for 8 total characters. ex: Todd's Welding = TODDWELD New Directions = NEWDIRE (notice this is only 7, which is OK) Kingston Technologies = KINGTECH ELSE IF 3.) the company name only has 1 word in the name then I want the first 4 letters from the word and then "TEMP" appended to the end for 8 total characters. ex: Sears = SEARTEMP Amazon = AMAZTEMP Selfies = SELFTEMP Art = ARTTEMP END NO SPACES & NO SPECIAL CHARACTERS allowed ALPHA & NUMBER based characters only.
Project ID: 7895528

About the project

5 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello - I am an experienced Access developer and understand the specifications that you posted. I can start straight away and will have the work done and delivered within the next hour. Please contact me if you have any questions, or if you would like me to assist with your project. Thanks - Karin
$20 USD in 1 day
4.7 (5 reviews)
3.1
3.1
5 freelancers are bidding on average $21 USD for this job
User Avatar
I am a full time freelancer with over 3 years of experience in Web design and development (Microsoft technologies such as Asp.net, vb.net, c#, mvc, web api, signalr). I am an expertise in bootstrap, responsive design, prototypes, html, css and jquery.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! I can make simple VBA formula for what you need, and even use later. I can do it within 15 minutes. Please contact me via my email for details.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi sir, I am a hardcore vba developer with more than 6 years of work experience. I worked on various projects in Ms access. Regards, Shekhar Kangale
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
will give you 100% accurate and efficient output.........................................................................................................
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Hutchinson, United States
5.0
74
Payment method verified
Member since Apr 5, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.