Is it possible to globally update a Catalog Title name that has a specific common word in each title. We would like to find the common word and replace /rename it with another. We have hundreds of Catalog items needing a specific word rename and would not like to open each one to rename.
Thanks!
Jun 01, 2020 11:07 AM
The catalog item titles are stored in the WD_WebPackages table in the column PackageTitle.. As such, I think that a query similar to the following would work for you..
update WD_webpackages
set PackageTitle = Replace(PackageTitle, 'notepad', 'textpad')
The above query will replace the word "notepad" with "textpad" for every row (for each catalog item)
Jun 01, 2020 11:21 AM
Hi Charles,
Thanks for the information! Really appreciate the quick reply.
Mike
Jun 01, 2020 11:32 AM