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…

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: <title>()</title> 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: #<PG::Result:0x00007feb4faf0298 status=PGRES_COMMAND_OK ntuples=0 nfields=0 cmd_tuples=6518> but the titles haven’t changed.

#<PG::Result:0x00007fc60eab0ca8 status=PGRES_COMMAND_OK ntuples=0 nfields=0 cmd_tuples=0> 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 10월 27, 2017, 2:42오후 9

Forgot to clear both fancy_title and slug columns. Query updated

글		댓글	조회수
Replace a string in all posts Self-Hosting how-to	26	23761	12월 9, 2025
How to repair old titles? Product Support	15	2000	12월 30, 2017
Replace words in posts with other words doesn't work on topic titles Product Support	1	461	9월 29, 2021
In the title, "''' are still converted in " ›" Product Support	9	924	8월 26, 2019
Batch processing to search and replace in all posts Development rest-api	6	4230	8월 17, 2016

How to replace a string/character in topic title?

Related topics