Shared in this post are a bunch of Notepad++ macros I use to reformat data copied from online storefronts (
yodobashi for physical,
e-onkyo for digital) into a suitable format to be added to the notes section of VGMdb. All the macros are essentially a series of regex find & replaces.
To use: Download the following file:
https://pastebin.pl/view/raw/cd3cc468 (right click -> save as with name "shortcuts.xml")
Assuming you aren't already using any macros, you can replace your shortcuts.xml with this file. The file by default is found in %APPDATA%\Notepad++ - entering this in Windows Explorer's navigation bar will take you to the correct directory. If Notepad++ is already running you'll need to restart Notepad++.
If you already have macros in Notepad++ you may wish to backup your shortcuts.xml file elsewhere, or combine my macros into your shortcuts.xml file.
Included macros:
1. Reformat Yodobashi
Example input
Expected output
Spoiler:
Code:
M-01
Performer: LiSA
Composer: 田淵智也
Arranger: 堀江晶太
Lyricist: LiSA, 田淵智也
M-02
Performer: 藍井エイル
Composer: 小川智之
Arranger: Saku
Lyricist: Eir, 小川智之
M-03
Performer: EGOIST
Composer: ryo
Arranger: ryo
Lyricist: ryo
参加アーティスト:chelly
M-04
Performer: SawanoHiroyuki[nZk]:Tielle & Gemie
Composer: 澤野弘之
Arranger: 澤野弘之
Lyricist: 澤野弘之, Tielle
M-05
Performer: PENGUIN RESEARCH
Composer: 堀江晶太
Arranger: 堀江晶太, PENGUIN RESEARCH
Lyricist: 堀江晶太
M-06
Performer: 斉藤壮馬
Composer: 斉藤壮馬
Arranger: Saku
Lyricist: 斉藤壮馬
M-07
Performer: 佐香智久
Composer: Takao Nagatani
Arranger: Sorao Mori
Lyricist: Tomohisa Sako, Tomoyuki Ogawa
M-08
作詞:北川勝利
作曲:北川勝利
編曲:北川勝利
ストリングスアレンジ:宮川弾
歌:花澤香菜
M-09
Performer: 三月のパンタシア
Composer: 40mP
Arranger: 40mP
Lyricist: 40mP
M-10
Performer: 春奈るな
Composer: Saku
Arranger: Saku
Lyricist: Saku
M-11
Performer: halca
Composer: 川崎智哉
Arranger: 川崎智哉
Lyricist: 宮嶋淳子
M-12
Performer: ClariS
Composer: kz
Arranger: kz
Lyricist: kz
M-13
Performer: TrySail
Composer: 中野領太
Arranger: 中野領太
Lyricist: 中野領太
M-14
Performer: GARNiDELiA
Composer: toku
Arranger: GARNiDELiA
Lyricist: メイリア
M-15
Performer: EGOIST
Composer: ryo
Arranger: ryo
Lyricist: ryo
参加アーティスト:chelly
M-16
Performer: PENGUIN RESEARCH
Composer: 堀江晶太
Arranger: 堀江晶太, PENGUIN RESEARCH
Lyricist: 堀江晶太
M-17
Performer: スピラ・スピカ
Composer: 寺西裕二
Arranger: If I
Lyricist: 幹葉, 高橋久美子
M-18
Performer: 綾野ましろ
Composer: masahiro mizoguchi
Arranger: toku
Lyricist: meg rock
M-19
Performer: ELISA
Composer: しほり
Arranger: 佐々木裕
Lyricist: zopp
M-20
Performer: ReoNa
Composer: ハヤシケイ
Arranger: PRIMAGIC
Lyricist: ハヤシケイ
M-21
Performer: =LOVE
Composer: 渡辺尚
Arranger: 古川貴浩
Lyricist: 指原莉乃
M-22
Performer: 佐香智久
Composer: Tomoyuki Ogawa
Arranger: Saku
Lyricist: Tomohisa Sako
M-23
Performer: 春奈るな
Composer: 増谷賢
Arranger: 増谷賢
Lyricist: 春奈るな, 増谷賢
M-24
Performer: ClariS
Composer: 野村陽一郎
Arranger: 野村陽一郎
Lyricist: ケリー
M-25
Performer: 三月のパンタシア
Composer: ARCHITECT
Arranger: ARCHITECT
Lyricist: 岡田麿里
M-26
Performer: 藍井エイル
Composer: HISASHI
Arranger: DJ Mass, Shoko Mochiyama
Lyricist: HISASHI
M-27
Performer: LiSA
Composer: 田淵智也
Arranger: PABLO aka WTF!?
Lyricist: LiSA, 田淵智也
M-28
Performer: TrySail
Composer: 山﨑佳祐
Arranger: 溝口雅大
Lyricist: 山﨑佳祐
M-29
Performer: SawanoHiroyuki[nZk]:mizuki
Composer: 澤野弘之
Arranger: 澤野弘之
Lyricist: 澤野弘之, mpi
M-30
Performer: ASCA
Composer: 重永亮介
Arranger: 重永亮介
Lyricist: 重永亮介
M-31
Performer: ELISA
Composer: 西木康智
Arranger: 前口渉
Lyricist: KOTOKO
M-32
Performer: 綾野ましろ
Composer: Carlos K., Toshi-Fj
Arranger: Carlos K.
Lyricist: meg rock
M-33
Performer: 藍井エイル
Composer: 重永亮介
Arranger: 重永亮介
Lyricist: meg rock
M-34
Performer: GARNiDELiA
Composer: toku
Arranger: GARNiDELiA
Lyricist: meg rock
M-35
Performer: LiSA
Composer: 田淵智也
Arranger: 江口亮
Lyricist: LiSA
Limitations: All four credits of 作詞, 作曲, 編曲, 歌/歌と演奏 are required. If for example the arranger credit is missing it won't work. Credits fields other than these four are not processed (e.g. 参加アーティスト in M-03). Some times the presence of non-standard credits may cause it to fail (e.g. ストリングスアレンジ in M-08).
Tip: When using find & replace to replace kanji names with romanized ones, you can highlight a name and press Ctrl+H to have it copied over to the find & replace dialog.
2. Reformat Yodobashi (Remove Performer)
Meant for use with albums with a single performer.
Example input
Expected output
Limitations: Same as above. Although in this case 歌/歌と演奏 isn't required.
3. Reformat e-onkyo
Example input
Spoiler:
Copied from
https://www.e-onkyo.com/music/album/laca15792/
Code:
1 相田詩音[アーティスト], 遠藤瑠香[アーティスト], 巴山萌菜[アーティスト], 安藤紗々[作詞], 中野領太 (onetrap)[作曲], 中野領太 (onetrap)[編曲]
2 巴山萌菜[アーティスト], 安藤紗々[作詞], 丸山真由子[作曲], 大西克巳[編曲]
3 遠藤瑠香[アーティスト], 安藤紗々[作詞], 宇田川 生[作曲], ats-[編曲]
4 TRUE[アーティスト], 唐沢美帆[作詞], h-wonder[作曲], h-wonder[編曲]
5 遠藤瑠香[アーティスト], 巴山萌菜[アーティスト], 安藤紗々[作詞], 宇田川 生[作曲], 渡辺徹[編曲]
6 相田詩音[アーティスト], 遠藤瑠香[アーティスト], 巴山萌菜[アーティスト], 安藤紗々[作詞], 森本貴大[作曲], 森本貴大[編曲]
Expected output
Limitations: Will work for most vocal albums on e-onkyo, but for labels using a non-standard format for credits (i.e. Universal Music LLC) it will not work as intended. Once again all four credits are required for the macro to function as intended.
4. Reformat e-onkyo (Remove Performer)
Meant for use with albums with a single performer.
Example input
Spoiler:
Copied from
https://www.e-onkyo.com/music/album/smj4580074472720/
Code:
1 麻倉もも[MainArtist], 月丘りあ子[Lyricist], 小久保祐希[Composer], YUU for YOU[Composer], YUU for YOU[Arranger]
2 麻倉もも[MainArtist], Giz'Mo (from Jam9)[Lyricist], YUU for YOU[Composer], Giz'Mo (from Jam9)[Composer], YUU for YOU[Arranger]
3 麻倉もも[MainArtist], Mahiro[Lyricist], 宮川 麿[Composer], 宮川 麿[Arranger]
4 麻倉もも[MainArtist], 宮嶋淳子[Lyricist], 川崎智哉[Composer], 川崎智哉[Arranger]
5 麻倉もも[MainArtist], Mahiro[Lyricist], KOUTAPAI[Composer], KOUTAPAI[Arranger]
6 麻倉もも[MainArtist], HoneyWorks[Lyricist], HoneyWorks[Composer], HoneyWorks[Arranger]
7 麻倉もも[MainArtist], 月丘りあ子[Lyricist], 山田竜平[Composer], 山田竜平[Arranger]
8 麻倉もも[MainArtist], 松嶋つきほ[Lyricist], 佐々倉有吾[Composer], 佐々倉有吾[Arranger]
9 麻倉もも[MainArtist], 月丘りあ子[Lyricist], アッシュ井上[Composer], アッシュ井上[Arranger]
10 麻倉もも[MainArtist], HoneyWorks[Lyricist], HoneyWorks[Composer], HoneyWorks[Arranger]
11 麻倉もも[MainArtist], 宮嶋淳子[Lyricist], 河原レオ[Composer], 河原レオ[Arranger]
12 麻倉もも[MainArtist], 藤田麻衣子[Lyricist], 藤田麻衣子[Composer], KOUTAPAI[Arranger]
13 麻倉もも[MainArtist], 渡辺 翔[Lyricist], 渡辺 翔[Composer], 倉内達矢[Arranger]
Expected output
Limitations: Much the same above.
5. Composer List
Gives a comma delimited list of composers.
Example input
Expected output
Spoiler:
Code:
Katsuhiko Kurosu, Kei Hayashi, toku, Katsuhiko Kurosu, Yuya Abe, Yusuke Nomura, megane, megane, 5u5h1, Kodai Akiba, Junxix., Kodai Akiba
Limitations:
- Exact match for "Composer: " is required.
- Additional information in parentheses is
NOT removed, because I prefer to do this on a case-by-case basis (for example, because some albums may contain unit members in parentheses).
- Duplicates are
NOT removed.
Tips:
- To remove all content in parentheses, use find and replace to find \s[\(\[].+?[\)\]] with search mode as regular expression.
- There are online tools to remove duplicates from comma delimited lists. For example I often use
https://www.helperset.com/tools/remo...ates-from-list
6, 7 & 8. Arranger, Lyricist, Performer List
Same as above but with Arranger, Lyricist and Performer. With Arranger any role ending in "Arranger: " will be processed (e.g. Strings Arranger, Horn Arranger).
Limitations:
- Same as above.
Tips:
- If you have Character Name (CV: Voice Actor) find [^,]+?\(CV:(.+?)\) and replace with \1
AFTER generating the list. Once again with search mode as regular expression.
9. Reformat mora Tracklist
For reformatting text copied from mora into a VGMdb submittable format.
Example input
Expected output
Limitations: Only guaranteed to work with text copied from Chrome. For example the same content copied from Firefox ends up pasting slightly different.
10. Reformat iTunes Tracklists
For reformatting text copied from iTunes into a VGMdb submittable format. Use
https://chrome.google.com/webstore/d...fmhpkanfnojjch to enable copying from the iTunes web pages.
Example input
Expected output
Limitations:
- Only tested with text copied out of Chrome.
- Only works with the English and Japanese storefronts.
- May fail with song titles that include ":" in the song name.
- Additional text at the top may mess with the first track title. Additional text at the bottom is fine.