When I make a new item I go by my distributers description for item description. The first part of the description is an abbreviated name for manufacturer. Over the years these abbreviations have changed slightly from time to time, so what I am left with now is multiple abbreviations for the same manufacturer. This can cause some confusion with my staff, so I have decided it is time to do a little spring cleaning, and get these abbreviations standardized for all my items. right now the only way I can see to do this is by going into each items properties and changing it manually. With 6000 items total, and about 1000 that need cleaned up, this is going to be quite a chore. What I need is to be able to change the first word(abbreviation) of the description in a group of items determined by an ILC grouping(ex: 1001 - 1100) to the same abbreviation. Does somebody have a faster way to do this, by SQL maybe? Thanks for any help. Craig
Spring cleaning
Apr 19, 2008
6 Replies
Craig,
Please give me an example
Ahmed, Thanks for the reply. I will be in the office tomorrow and will give a detailed example when I get in. I really appreciate your (and others) willingness to share your knowledge. Craig
Ahmed, As an example: The description on Items with ILC's 09761266104 through
09761280032 (the first 6 numbers are unique to each manufacturer) belong to the manufacturer Zoo Med and might start with ZOO MED, ZMED, or ZML, I want to make all items start with ZML. I have many different products from different manufacturers that I need to do this with. I hope this makes sense. CraigCraig,
use the 2 following updates for the example u mentioned, please BACKUP FIRST
update item
set description = 'ZML' + substring(description,5,len(description)-4)
where itemlookupcode between '09761266104' and '09761280032'
and description like 'ZMED%'
update item
set description = 'ZML' + substring(description,8,len(description)-7)
where itemlookupcode between '09761266104' and '09761280032'
and description like 'ZOO MED%'
Thank you so much Ahmed, this is going to save me gobs of time. I'll let you know how things go. I am waiting until I close to do this. Craig BTW, maybe you forgot to send me a demo of your forecasting utility, in case you did, here's my email snipped-for-privacy@netzero.net
Ahmed, The queries worked perfectly. Thanks again for your help, I just can't express enough how much time you have saved me. Craig
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required