XF 2.2 Old [AME] bbcode from vBulletin board: replace it with new [MEDIA]

[Scandal]

I'm planning to import a vBulletin 3 board to my xF2.2 site.
I have stack on this issue:
There are ~9000 posts with the following bbcode from an old vBulletin addon:

[ame="https://www.youtube.com/watch?v=GEPvsn6JA_c"]this is the video title / useless info currently[/ame]

I want to replace / canonicalize it with the new [MEDIA] tag:

[MEDIA=youtube]GEPvsn6JA_c[/MEDIA]

Any idea?
I just need a REPLACE query with the correct regular expression.

 

[KevinL]

You could use this https://xenforo.com/community/threads/post-content-find-replace.135904/

Read the version 1 for more https://xenforo.com/community/resources/post-content-find-replace.1549/

 

[Scandal]

Thanks!
I'm in a good way to achieve what I need.

Here is what I enter on the form:
Quick find: [ame=
Regular expression: #\[ame=([^\]]+)\]([^\[]+)\[/ame\]#siU
Replacement string:

[media=youtube]\1[/media]

The result:
Matched text: [ame="[MEDIA=youtube]zXHPk-ctoYY[/MEDIA]"]tonight i can write the saddest lines - pablo neruda - YouTube[/ame] Replacement:

 [media=youtube]"http://www.youtube.com/watch?v=zXHPk-ctoYY"[/media]

My question:
1. how could I remove the "" (quotes) on the \1 (the youtube url insde the replacement bbcode) ?
Sorry, I don't have knowledge of regular expressions.
2. How I can get the youtube id instead of the full url?

 

[Scandal]

ok I found this on the addon's discussion. Problem solved

[ame=
#(?:\[ame="[^\.]+\.youtube\.com/watch\?v=)([a-z0-9_-]{11})(?:(?:.*?(?!"]?)).)?(?:"])(?:.*?(?!\[/ame]?).)(?:\[/ame])#siu
[media=youtube]\1[/media]