|
|||||||
 |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
May 18, 2020, 09:36 PM
|
|||
|
|||
Notepad++ macros to aid submission of commercial vocal albums
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 Spoiler:
Expected output Spoiler:
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 Spoiler:
Expected output Spoiler:
Limitations: Same as above. Although in this case 歌/歌と演奏 isn't required. 3. Reformat e-onkyo Example input Spoiler:
Expected output Spoiler:
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:
Expected output Spoiler:
Limitations: Much the same above. 5. Composer List Gives a comma delimited list of composers. Example input Spoiler:
Expected output Spoiler:
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 Spoiler:
Expected output Spoiler:
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 Spoiler:
Expected output Spoiler:
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. Last edited by nstz; Jul 23, 2020 at 10:28 AM. 
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to use "commercial" in artist links? | Nicolaas Hamman | Questions and Comments | 1 | Dec 15, 2019 03:53 PM |
| New Submission to the Database | VGMLover | Video Game Music Discussion | 2 | Nov 5, 2017 09:14 PM |
| Submission Feedback | Secret Squirrel | News and Announcements | 6 | Oct 7, 2011 04:21 AM |
| Link submission page for albums | Gigablah | Questions and Comments | 8 | May 1, 2009 12:25 PM |
| Anime Games Albums submission RULES. | NEOBEJITA | Miscellaneous Discussion | 4 | Feb 18, 2008 09:26 AM |
Linear Mode
