by sean » Sat Sep 23, 2023 3:00 pm
I just accomplished this using Google Sheets.
I put all the titles of the tracks I want in my playlist in column A. I put the paths of all my available tracks in column C.
In column B, I put =VLOOKUP("*"&A1&"*", C:C, 1, FALSE).
This gave me a list of the full paths of all the tracks I wanted based on the titles in col A.
I just accomplished this using Google Sheets.
I put all the titles of the tracks I want in my playlist in column A. I put the paths of all my available tracks in column C.
In column B, I put =VLOOKUP("*"&A1&"*", C:C, 1, FALSE).
This gave me a list of the full paths of all the tracks I wanted based on the titles in col A.