Mapping capability

[cfogarty]

Along the lines of another post. Is there a way to script or create mapping that will do things like this:

### Russian Composers:

Pjotr Tschaikowski, Piotr Ilitch Tchaïkovski → Pyotr Ilyich Tchaikovsky
Sergey Rachmaninov, Serge Rachmaninoff, Sergej Rachmaninow → Sergei Rachmaninoff
Modest Musorgsky, Modest Petrovich Mussorgski → Modest Mussorgsky
Nikolay Rimsky-Korsakoff → Nikolai Rimsky-Korsakov
Dmitrii Shostakovitch, Dmitrij Shostakovich → Dmitri Shostakovich
Sergey Prokofiev, Serge Prokofieff → Sergei Prokofiev
Aleksandr Scriabin, Alexander Skryabin → Alexander Scriabin
Michail Glinka, Mikhail Ivanovich Glinka → Mikhail Glinka
Aram Ilyich Khachaturian, Aram Chačaturjan → Aram Khachaturian
Reinhold Moritzevich Glière, Rheinhold Glière → Reinhold Glière

French Composers:

Achille-Claude Debussy → Claude Debussy
Joseph Maurice Ravel → Maurice Ravel
Charles-Camille Saint-Saëns → Camille Saint-Saëns
Gabriel Urbain Fauré → Gabriel Fauré
Olivier Eugène Prosper Charles Messiaen → Olivier Messiaen

German/Austrian Composers:

J.S. Bach, Johann S. Bach → Johann Sebastian Bach
Louis van Beethoven → Ludwig van Beethoven
Johann Brahms → Johannes Brahms
Wilhelm Richard Wagner → Richard Wagner
Franz Joseph Haydn → Joseph Haydn
Franz Peter Schubert → Franz Schubert
Gustav Mähler → Gustav Mahler
Anton Josef Bruckner → Anton Bruckner

Italian Composers:

Joseph Verdi → Giuseppe Verdi
Antonio Lucio Vivaldi → Antonio Vivaldi
Giuseppe Domenico Scarlatti → Domenico Scarlatti
Giacomo Antonio Domenico Michele Secondo Maria Puccini → Giacomo Puccini

Eastern European Composers:

Bela Bartok → Béla Bartók
Zoltan Kodaly → Zoltán Kodály
Antonin Dvorak → Antonín Dvořák
Leos Janacek → Leoš Janáček
Karl Szymanowski → Karol Szymanowski

Other Composers with Name Variations:

Edward Grieg → Edvard Grieg
Johan Sibelius → Jean Sibelius
Isaac Manuel Francisco Albéniz → Isaac Albéniz
Manuel María de los Dolores Falla → Manuel de Falla
Joaquin Rodrigo → Joaquín Rodrigo
Heitor Villa Lobos → Heitor Villa-Lobos
Ástor Pantaleón Piazzolla → Astor Piazzolla

I would love that whenever it finds the first in fix songs it makes this swap

[paultaylor]

Hi, yes you could use the Scripter task and write a script that has two arrays, if match for composer in first array set composer to the value at the same index in the second array

e.g

I have done it for first two cxomposers in your list

var array1 = [
"Pjotr Tschaikowski", 
"Piotr Ilitch Tchaïkovski",
"Sergey Rachmaninov",
"Serge Rachmaninoff",
"Sergej Rachmaninow"];

var array2 = [
"Pyotr Ilyich Tchaikovsky", 
"Pyotr Ilyich Tchaikovsky",
"Sergei Rachmaninoff",
"Sergei Rachmaninoff",
"Sergei Rachmaninoff"];

var matchIndex = array1.indexOf(composer)
if(matchIndex> -1){
   composer=array2[matchIndex];
}

[cfogarty]

You are a rock star! I just bought Jaikoz for manual edits. I love the spreadsheet aspect!