JackChang
04-24-2023, 06:42 PM
Hi All,
My company is trying to create customer numbers using their name and they want to string the first 3 letters of the first word, and the first 3 letters of the second word. Each customer # should only be 6 characters.
There is an exception, they do not want to include special characters such as & * . _ , etc
For example:
Aloha Power Equipment = Alopow
Island Insurance Companies = Islins
Pacific Venture Associates LLC = pacven
Some vendors do not have 3 letters in their first name and the guidelines are unclear here. Anything will do for these in my opinion. I just strung together 3 letters using the first and second word, then take the next 3 letters from the third word.
A & R Painting Services = ARPSER
A to Z Roofing = AtoZro or AtoRoo
Is it possible to create a formula for this? If it's not possible for the exceptions I can always do it manually. Attached sample list.
Thank you
My company is trying to create customer numbers using their name and they want to string the first 3 letters of the first word, and the first 3 letters of the second word. Each customer # should only be 6 characters.
There is an exception, they do not want to include special characters such as & * . _ , etc
For example:
Aloha Power Equipment = Alopow
Island Insurance Companies = Islins
Pacific Venture Associates LLC = pacven
Some vendors do not have 3 letters in their first name and the guidelines are unclear here. Anything will do for these in my opinion. I just strung together 3 letters using the first and second word, then take the next 3 letters from the third word.
A & R Painting Services = ARPSER
A to Z Roofing = AtoZro or AtoRoo
Is it possible to create a formula for this? If it's not possible for the exceptions I can always do it manually. Attached sample list.
Thank you