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: [imagem] 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 Outubro 27, 2017, 2:42pm 9

Forgot to clear both fancy_title and slug columns. Query updated

Tópico		Respostas	Visualizações
Replace a string in all posts Self-Hosting how-to	26	23765	9 de Dezembro de 2025
How to repair old titles? Product Support	15	2010	30 de Dezembro de 2017
Replace words in posts with other words doesn't work on topic titles Product Support	1	461	29 de Setembro de 2021
In the title, "''' are still converted in " ›" Product Support	9	924	26 de Agosto de 2019
Batch processing to search and replace in all posts Development rest-api	6	4233	17 de Agosto de 2016

How to replace a string/character in topic title?

Tópicos relacionados