Find Jobs
Hire Freelancers

Truncate Company Name Field based on characters and spacing

$10-30 USD

已完成
已发布将近 9 年前

$10-30 USD

货到付款
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: 7895528

关于此项目

5提案
远程项目
活跃9 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在1天之内
4.7 (5条评论)
3.1
3.1
5威客以平均价$21 USD来参与此工作竞价
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
will give you 100% accurate and efficient output.........................................................................................................
$25 USD 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Hutchinson, United States
5.0
74
付款方式已验证
会员自4月 5, 2005起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。