Mangled CSV using Media Indexer script

[karanrajpal14]

Hey I just found your Media Indexer script from here:

Code: Select all

https://www.filebot.net/forums/viewtopic.php?f=4&t=5#p53

I was really happy that I wouldn't have to do something like this on my own but once I gave the script a shot the CSV produced was all messed up. The first column had almost all the data dumped into it. I've added a screenshot of what it looks like and a link to the csv as well. Would you please have a look and try to fix it? I'd appreciate it.

Screenshot:

Code: Select all

https://www.dropbox.com/s/dhl477vc2dc5vf8/Screenshot%20%2833%29.png?dl=0

CSV:

Code: Select all

https://www.dropbox.com/s/qvnetoekxm7d6vm/tvVSV.csv?dl=0

Thank you very much!

[rednoah]

Make sure that you select ; as separator when importing the CSV file.

[karanrajpal14]

Make sure that you select ; as separator when importing the CSV file.

Excel 2016 doesn't allow me to do that from what I've gathered. I did find a solution on SuperUser that said that this is region dependent. So, if you've got some free time, would you please modify the script in such a way that we can specify what delimiter we can use and as a precaution, append sep=<selected seperator> to the first line to ensure proper compatibility. I've posted a link to the answer below. Please have a look and fix it if you can. Thank you!

https://superuser.com/a/420025

[rednoah]

You can just use Google Sheets instead. That'll let you define the separator when importing csv files. I'm inclined to change the separator to TAB through.

[karanrajpal14]

You can just use Google Sheets instead. That'll let you define the separator when importing csv files. I'm inclined to change the separator to TAB through.

That works! Although, is it difficult to change the script to add a user-defined delimiter? Too much work? I'm still inclined towards commas as they "just work". Will TABs work in the same way?

[rednoah]

1.
Not really. The script is just a few lines so it's meant to be modified to your needs.

2.
I prefer tab as separator because columns generally don't contain tab characters. Not sure if Excel works well with that though.

[karanrajpal14]

Where can I find the script? I'd like to have a look and see if I can modify it. Might even test and see if Excel works fine with tabs or not.

[rednoah]

Scripts are on GitHub. Use -script dev:mi to try the latest revision of the script.

Please read the manual: viewtopic.php?f=4&t=5