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 2017 年 10 月 27 日午後 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	23762	2025 年 12 月 9 日
How to repair old titles? Product Support	15	2004	2017 年 12 月 30 日
Replace words in posts with other words doesn't work on topic titles Product Support	1	461	2021 年 9 月 29 日
In the title, "''' are still converted in " ›" Product Support	9	924	2019 年 8 月 26 日
Batch processing to search and replace in all posts Development rest-api	6	4230	2016 年 8 月 17 日

How to replace a string/character in topic title?

関連トピック