Search
Other DB Replacer questions
Forum

15000 Datensätze ändern

Th. Junge's Avatar Th. Junge
Hallo,
I have approx. 15000 data records in the content table in the book title from the publishers. This is not good and so I would like to replace the hard links with a placeholder. All links start with the same syntax:
http://media.buch.de/img-adb/36276152-00-03/rechtsterrorismus_in_den_medien.jpg
Example: <img src="http://media.buch.de/img-adb/36276152-00-03/rechtsterrorismus_in_den_medien.jpg" alt="">

Only after the last / is the link different. However, all links should be replaced with the placeholder /images/icons/nopic.png
Example: <img src="/images/icons/nopic.png" alt="">

I still have to do the same with 8000 Amazon images. Surely there is a RegEX for this? Can someone help me?
Peter van Westen's Avatar Peter van Westen ADMIN
So what part of the image url is unique and what is the same for all those images?
Please post a rating at the Joomla! Extensions Directory
Th. Junge's Avatar Th. Junge
Hello, thank you very much for the quick processing, I didn't expect it to be so fast!
So, the syntax always starts with:
<img src="http://media.buch.de....
The end is always unique:
...img-adb/36276152-00-03/rechtsterrorismus_in_den_medien.jpg
I hope I expressed myself correctly 🙂
Greeting Thorsten
Peter van Westen's Avatar Peter van Westen ADMIN
Try:
Search (Regular Expressions):
<img src="http://media\.buch\.de/.*?>
Replace:
<img src="/images/icons/nopic.png" alt="">
Please post a rating at the Joomla! Extensions Directory
Th. Junge's Avatar Th. Junge
Hello,
I'm really overwhelmed! It is working. Thank you for the help, I am amazed at the speed of the help! Many Thanks!! Greetings from Hamburg, Thorsten
You can only post on the extension support forum if you have an active subscription and you log in

Buy a Pro subscription