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: [תמונה] 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.

החלפת תוכן בנושאים מרובים באמצעות Regex?

תמיכה הגירה

pfaffman (Jay Pfaffman) 9 בפברואר,‏ 2024,‏ 3:37pm 6

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

נושא		תגובות	צפיות
Replace a string in all posts Self-Hosting how-to	26	23898	9 בדצמבר,‏ 2025
Global Replace across database Product Support	3	1482	18 בינואר,‏ 2017
Batch processing to search and replace in all posts Development rest-api	6	4265	17 באוגוסט,‏ 2016
What's the fastest way to replace strings with multiple regexes in 1 million posts? Product Support	8	988	22 באוגוסט,‏ 2020
Is there a way to easily replace the word "Topic" everywhere on my site at once Product Support	5	1071	17 בנובמבר,‏ 2021

החלפת תוכן בנושאים מרובים באמצעות Regex?

נושאים קשורים