Using a csv file for lists
Posted: 12 Jun 2024, 06:15
Red, you helped me long ago set up the code to read a file and make changes to movie ratings. The code is:
Inside that file I have this list:
UNRATED;NR
Not Rated;NR
NOT RATED;NR
APPROVED;NR
N A;NR
N R;NR
;NR
And it works perfectly every time.
I now need one for subs. I'll start with my list (this is my test list):
SDH.eng;eng-SDH
[Forced].nor;nor-Forced
Danish [Forced].dan;dan-Forced
And this is the code I was trying:
I have tried with and without the {""}} at the end and currently, it doesn't matter either way.
When the movie folder contains subs and one of them is a sub with Danish [Forced].dan as part of one of the sub files names it simply has .dan as the language instead of dan-Forced
What I see under the Movie Format is: Pattern not found: 3D: Danish [Forced].dan
Is this because it isn't reading the file correctly? Did I not call the file correctly?
I hope that makes sense.. I am trying to have a list with a crap ton of subs listed. I keep finding that people label these files with all sorts of variations of what it should be so I will have a list of many many changes.
Thanks as always for any help....
Greg
Code: Select all
{any{csv('S:/replacecert1.csv').get(certification)}{certification}{"NR"} }
UNRATED;NR
Not Rated;NR
NOT RATED;NR
APPROVED;NR
N A;NR
N R;NR
;NR
And it works perfectly every time.
I now need one for subs. I'll start with my list (this is my test list):
SDH.eng;eng-SDH
[Forced].nor;nor-Forced
Danish [Forced].dan;dan-Forced
And this is the code I was trying:
Code: Select all
{any{csv('S:/replacesubt1.csv').get(subt)}{subt}{""}}
When the movie folder contains subs and one of them is a sub with Danish [Forced].dan as part of one of the sub files names it simply has .dan as the language instead of dan-Forced
What I see under the Movie Format is: Pattern not found: 3D: Danish [Forced].dan
Is this because it isn't reading the file correctly? Did I not call the file correctly?
I hope that makes sense.. I am trying to have a list with a crap ton of subs listed. I keep finding that people label these files with all sorts of variations of what it should be so I will have a list of many many changes.
Thanks as always for any help....
Greg