The DLMSTR should be :: and then you need to parse GENRE out separately after, because the number of entries there are not consistent, some have 1, some have 3 genres. Make sure to parse out the year as well. For either you can use the SCAN function.
There are some other data issues throughout.
There's actually code on here somewhere on how to read the file properly, someone else asked this already.
... View more