linux - 使用电子表格中的数据标记音频文件

我的音乐库中保存了披头士乐队录制的所有音乐，并将其分为专辑目录。大多数是* .flac。当我在音乐播放器中打开文件时(Linux.Ubuntu.14.04上的rhythmbox)。我想编写一个简单的bash循环来根据电子表格设置composer标签，并从以下所有数据中提取数据:https://en.wikipedia.org/wiki/List_of_songs_recorded_by_the_Beatles
所以我可以从那里创建一个* .csv或* .tsv文件。

到目前为止，我还学习了如何使用名为flac(sudo apt-get install flac)的软件包和命令metaflac。
不幸的是，我没有编写循环的经验，但我知道它看起来应该像这样:

for{all files in the current directory}do
 metaflac --remove-tag=composer
done
for{untill reaching the end of file "The-Beatles.db.tsv"}do
 {locate file named as in left part of line x}
 metaflac --set-tag=composer=${right part of line x in file "The-Beatles.db.tsv"}
done

最佳答案

# https://docs.google.com/spreadsheets/d/1AnhIblgyA8yXRo-s5_zBpYEtgyFtkgqnLw_6eP5grMI/edit?usp=sharing
# URL above is the source of the .tsv file located in the same folder of this script
# **I've copied all the first 2 columns of the spreadsheet to "songs-composers.tsv"**

while read line; do
 IFS=$'\t'
 val=($(echo "$line"))
 # "${val[0]}" is the name of the song
 # "${val[1]}" is the name of the composer
 echo locating song: "${val[0]}"...
  IFS=$'\n'
 file=($(find -iname ""${val[0]}"*.flac"))
 echo "located files are:"
 for j in `seq 1 "${#file[@]}"`; do
  echo "    "${file[$((j-1))]}""
 done
 for j in `seq 1 "${#file[@]}"`; do # for every string in the array 'file'
  echo removing composer-tag for file:        "${file[$((j-1))]}"
  metaflac --remove-tag=composer "${file[$((j-1))]}"
  echo setting-up correct composer-tag as     "${val[1]}"
  metaflac --set-tag=COMPOSER="${val[1]}" "${file[$((j-1))]}"
 done
done < "songs-composers.tsv"

关于linux - 使用电子表格中的数据标记音频文件，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/32847410/