I used the following command to replace the [HEADING] tags that were not converted during the XenForo migration:
sudo -u discourse -H RAILS_ENV=production bundle exec rails runner '
Post.where("raw LIKE ?", "%[HEADING%]").find_each(batch_size: 500) do |p|
orig = p.raw
cooked = orig.dup
(1..6).each do |lvl|
cooked.gsub!(/\[HEADING=#{lvl}\](.*?)\[\/HEADING\]/mi) { "#" * lvl + " " + $1 }
end
cooked.gsub!(/\[HEADING\](.*?)\[\/HEADING\]/mi) { "## " + $1 }
next if cooked == orig
p.raw = cooked
p.save!(validate: false) # Trigger rebake, but skip validation
end
puts "HEADING tags converted & rebaked."
'