Find Jobs
Hire Freelancers

Truncate Company Name Field based on characters and spacing

$10-30 USD

Terminado
Publicado hace casi 9 años

$10-30 USD

Pagado a la entrega
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.
ID del proyecto: 7895528

Información sobre el proyecto

5 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
4,7 (5 comentarios)
3,1
3,1
5 freelancers están ofertando un promedio de $21 USD por este trabajo
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
will give you 100% accurate and efficient output.........................................................................................................
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Hutchinson, United States
5,0
74
Forma de pago verificada
Miembro desde abr 5, 2005

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.