Hey, in a lot of my imported content i have a link from the old domain in topics i imported like this: https://domain.com/threads/xxxx where xxxx is represented by a 4 digit thread number, I just want to complete remove this string from all topics, what would be the best way to achieve this en-bulk to 3,000+ topics?

Hi, This should help: [image] Replace a string in all posts Self-Hosting bookmark This guide explains how to replace a string in all posts within a Discourse instance. person_raising_hand Required user level: System Administrator warning Console Access Required Want to replace a string in all the posts on a site? Let’s get started! warning WARNING: We strongly recommend you take a full backup before proceeding, and make sure your string replacement is specific enough to affect only the places you want it to. If this string replacement goes wrong, every…

Hey thanks! rake posts:delete_word['^http:\/\/domain.com\/threads\/.*.\/$','regex'] pulls up 0 results, know where I’m going wrong?

Try: rake posts:delete_word['https?://domain\.com/threads/\\d{4}','regex']

Amazing! worked perfectly, been reading the post you linked and im trying to build a regex for removing RGB BB code. RegEx builder states my regex is valid: [image] However when running it, it either updates 0 posts or I get an error stating it isn’t a valid regex. This his how the BBcode is in topics: [COLOR=rgb(95, 66, 222)] Also tried this: rake posts:delete_word[‘[\WCOLOR=rgb(\d{1,3}), (\d{1,3}), (\d{1,3})(, ){0,1}(0(\.\d+)?|1(\.0+)?)]’,‘regex’]

You can use my example in the other topic where this was discussed for how to do it in rails and use http://rubular.com/ to tweak your regex.

Replacing content in multiple topics with Regex?

Product Support Migration

pfaffman (Jay Pfaffman) February 9, 2024, 3:37pm 6

Wouldn’t you rather have those links work? And maybe just change the hostname?

Topic		Replies	Views
Replace a string in all posts Self-Hosting how-to	26	23895	December 9, 2025
Global Replace across database Product Support	3	1482	January 18, 2017
Batch processing to search and replace in all posts Development rest-api	6	4261	August 17, 2016
What's the fastest way to replace strings with multiple regexes in 1 million posts? Product Support	8	988	August 22, 2020
Is there a way to easily replace the word "Topic" everywhere on my site at once Product Support	5	1067	November 17, 2021

Replacing content in multiple topics with Regex?

Related topics