XF 1.4 Old FONT-Tags after Import from VBulletin

Arno Nühm

Active member
After Import from VBulletin to Xenforo we have a lot of old [ FONT ] Tags (without spaces) that are not rendered correctly.

I guess it's because of the comma inside, e.g.

[font=Verdana, Arial, Helvetica, sans-serif]
There are a lot of different FONT-Codes like that inside the xf_posts and I need to remove them all.

I would love to replace all font tags with at least one comma with the first font name and remove the rest.

[font=Verdana, Arial, Helvetica, sans-serif]
should be replaced to

There must be any regular expression in mysql to do this?

Can anyone please help me?