I did a test import of my phpBB forum to vB as the first step to converting to XenForo. Unfortunately, as expected, all of my custom BB Code is a mess. Due to the way phpBB appends a different hex string onto each BB Code/post combination, it's not a simple matter of doing a simple SQL REPLACE query. Here's an example of what some basic youtube and spoiler code looks like. Code: [media=youtube:3n7eycix]i_eQGsbHhDo[/media:3n7eycix] [media=youtube:3cyuajl6]owodGwwjv_o[/media:3cyuajl6] [spoiler=question:3df2kebg]Answer[/spoiler:3df2kebg] [spoiler=question:9cv8skji]Answer[/spoiler:9cv8skji] Table code is just as bad: Code: [tablebox:2l8tutbq][table:2l8tutbq][tr:2l8tutbq][th:2l8tutbq]Grand Prix[/th:2l8tutbq][th:2l8tutbq]Winning Driver[/th:2l8tutbq][th:2l8tutbq]Winning Constructor[/th:2l8tutbq][th:2l8tutbq]Time[/th:2l8tutbq][th:2l8tutbq]Pole Position[/th:2l8tutbq][th:2l8tutbq]Time[/th:2l8tutbq][th:2l8tutbq]Fastest Lap[/th:2l8tutbq][th:2l8tutbq]Time[/th:2l8tutbq][/tr:2l8tutbq][tr1:2l8tutbq][td1:2l8tutbq]Bahrain[/td1:2l8tutbq][td1:2l8tutbq] Notice the hex strings are different in each case. Therefore it looks like my only solution is to use regex, which is voodoo as far as I'm concerned So if anyone can help with constructing some regex to tidy up my BB Code, I'd be eternally grateful.