Shell Programming and Scripting

Please bear with me while I illustrate my objective again,
I am not sucessfully applying your suggestions.

File1: named "Playlist", delimiter is: " - "
File1 fields are: "Artist" "Title"

File2: named "Master-List", delimiter is: tab
File2 fields are: "Artist" "Title" "Bitrate" "Path"

Using the above examples... for each entry in "Playlist"
1. Use "Playlist" to store 2 variables for Field1 and Field2 (artist title)
2. Search for $title "Jammin (Bonus Track).mp3" inside Master-List
3. If matched, check that the $artist also is matched
4. if the $title and $artist match, print the 4th colunm in Master-List, else print "No Match".

Thanks for your interest in helping out.

Code:

# awk -F'-' 'NR==FNR{art=$1;gsub(/[()-%$@]|^[ ]*/,"",$2);tit=$2;next}{l=split($0,a,"\t");gsub(/[()-%$@]/,"",a[2]);mas=a[1];
for(i=2;i<=l;i++)mas=mas" "a[i];if(mas~tit)if(mas~art)print a[l];else print "No Match"}' Playlist Master-List
/Music/Bob Marley/ Jammin (Bonus Track).mp3

Thanks Chubler XL, ygemici.

I've carefully copied and pasted your codes, they do not return any result.
I'm using the debian version of awk (mawk), does that affect your suggestions?

Thank you for trying. I'm going to give it one last attempt to try and combine your suggestions into one.

1. The best way to avoid metacharacters is to use the 'index' function
2. The best way to approach comparing 2 files is to use an 'array'

With that in mind, to simplify, i've made all files tab seperated and removed the .mp3 .

Use 2 arrays from file1 "Playlist"...
Example Line from Playlist;

Then;
1. compare the indexed Title "Angel (Bonus Track)" to file2 "Master-Music-List" <field2> "Title"
2. check that the indexed Artist "Shaggy" matches "Master-Music-List" <field1> "Artist"

If 'both' array1 (title) , and array2 (artist) match, then print the result.

Example;

Match this from "Playlist" to "Master-Music-List";
Master-Music-List Lines:

This way, the song 'Angel (Bonus Track)' will match for Shaggy and not for Rolling Stones.

Could someone please help to include the arrays and index functions ?

Thank you.