I need a program to help me search a database and replace words?
Permalink
Hello,
I need to use a program that would take I.d. placed in a Microsoft excel file then search that id on a website (string) and replace the id with the name it finds. Would this CMU be able to help me do that?
Also, I have not done any programming before so I apologise.
If not, what are my options? I have about 1400 ids and not enough time?
Regards,
Rabia Ali
I need to use a program that would take I.d. placed in a Microsoft excel file then search that id on a website (string) and replace the id with the name it finds. Would this CMU be able to help me do that?
Also, I have not done any programming before so I apologise.
If not, what are my options? I have about 1400 ids and not enough time?
Regards,
Rabia Ali
I will add to what @exchangecore sais that is absolutely correct that you are also looking into opening and parsing an excel file through code and scrapping a website. Nothing trivial
I realise this is an old thread, but just in case someone stumbles across it, I have a new add-on that does a great job of finding & replacing content across the entire website - all blocks and all page attributes. Here's a link:https://www.concrete5.org/marketplace/addons/find-and-replace/...
Generally, I don't recommend people unfamiliar with the intricacies of a database doing bulk find/replace on any database tables/fields. This is a VERY dangerous thing to do if you don't know exactly what you're doing and what the side effects might be. It can be done using MySQL's REPLACE() function, but please make sure you take a database backup prior to attempting such things.
https://www.exchangecore.com/blog/mysql-find-and-replace-values/...
Generally, if this is something you will be doing frequently it likely means there is a better process that can/should be created. Consider hiring a developer to develop something that meets your specific needs rather than trying to force a system to do something it wasn't intended to.