I want to replace all the - in the topic title with a single space. this command will do it for all the posts, how can I change it so that only a topic-title get affected? rake posts:remap["-"," "]

Here’s my try. It’s not tested, so please backup first! I don’t know how this interacts with “encoded”. Perhaps that means that dashes are encoded as something other than a -. If that’s the case, you’ll need to modify things accordingly. Topic.where("title LIKE '%-%'").find_each do |topic| topic.title.gsub!(/-/," ") topic.fancy_title.gsub!(/-/," ") topic.slug.gsub!(/-/," ") puts topic.title begin topic.save! rescue puts "oops, something broke." end end

As mentioned before, use regular expressions :slightly_smiling_face: [תמונה]Replace a string in all posts We’re talking about RegEx: http://www.regular-expressions.info/

the regular expression for title should be something like this: () how can I search in title tags in the remap command? rake posts:remap[“-”," "]

rake post:remap does not change the title… I am not sure if any of the rake tasks does this. You are probably better off with a one time custom Ruby script.

That’s not possible using the remap rake task. You’ll have to use the rails console to do that. Something like this rails c Topic.exec_sql("UPDATE topics SET title = replace(title, '-', ' '), fancy_title = NULL, slug = NULL WHERE title <> replace(title, '-', ' ')")

thanks, but this command didn’t replaced the “-” in titles with space. any other suggestion would be appreciated.

I’ve edited my query, can you try again?

thanks, I tried it. the output is: # but the titles haven’t changed.

# no change has been made to titles :face_with_raised_eyebrow: update: slug is set to encoded in our case, should I change it in the command? @zogstrip

thanks, it gave back nil , just a double check to be sure I’m doing it right; I enter the app, then run the command in the rails console. sudo ./launcher enter app rails c

How to replace a string/character in topic title?

Product Support

zogstrip (Régis HANOL) 27 באוקטובר,‏ 2017,‏ 2:42pm 9

Forgot to clear both fancy_title and slug columns. Query updated

נושא		תגובות	צפיות
Replace a string in all posts Self-Hosting how-to	26	23898	9 בדצמבר,‏ 2025
How to repair old titles? Product Support	15	2046	30 בדצמבר,‏ 2017
Replace words in posts with other words doesn't work on topic titles Product Support	1	475	29 בספטמבר,‏ 2021
In the title, "''' are still converted in " ›" Product Support	9	945	26 באוגוסט,‏ 2019
Batch processing to search and replace in all posts Development rest-api	6	4265	17 באוגוסט,‏ 2016

How to replace a string/character in topic title?

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