My company is re-branding a few of our products. Our current descriptions use the branded item name as part of the description in all configurations of that product as well as all major components used in the manufacture of those items. Is there any way to do a "Find and replace" within the item description on a mass level? My first item name update will need to be changed on 803 different part numbers and I really don't want to do that manually. I am interested in any routines, addons or SQL scripts that would help with this
Thanks in advance
*This post is locked for comments
If the actual description is part of the table, and not just a reference to the master file, then you would also need to change that table. Specifically speaking about the Bill of Materials tables, the description is not included, only the item number. The description comes from the Item master. Any tables containing the item description such as a PO or SOP document will not change unless you specifically change those tables.
If you can get the old name/new name in a spreadsheet you can use the item description modifier.
Leslie
Thank you Leslie. This seems to be the way to go. I will try this in my test company first just to make sure. I had one question though. Will changing the description in the Inventory Master table conflict with any other tables? The Bill of materials table comes to mind.
Hi,
Like John mentioned, I think the SQL Replace with the Update statement would be the way to go. For instance, if my brand was 'Cellular One' and I wanted to change it to 'Cingular', the script would look something like this:
Update dbo.IV00101
Set ITEMDESC= replace(ITEMDESC, 'Cellular One', 'Cingular');
This example would change the words 'Cellular One' with the word 'Cingular' anywhere it existed in the ITEMDESC column of the IV00101 table. If 'Cellular One' didn't appear in the column, the ITEMDESC would not be changed.
Kind regards,
Leslie
I would create a list using Excel with the item number and new description and then import this into SQL. If you have some common theme to your description convention you could use the SQL REPLACE function in an update query. If you could provide a concrete example I could send over a sample script.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156