Spring cleaning


C

Craig

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
 
Ad

Advertisements

C

Craig

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
 
C

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.
Craig
 
A

Ahmed Nashat

Craig,

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%'
 
C

Craig

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 (e-mail address removed)
 
Ad

Advertisements

C

Craig

Ahmed,
The queries worked perfectly. Thanks again for your help, I just can't
express enough how much time you have saved me.
Craig
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clean audit 5
Cleaning software 3
cleaning data 1
Clean Uninstall 2
Clean-up - Condense 1
Cleaning up Accounts 3
cleaning old data 2
Export & Clean UP 2

Top