chowbok Posted May 11, 2019 Share Posted May 11, 2019 I'm not able to import CSV files into my spreadsheet program correctly because the Reports plugin uses semicolons for delimiters but doesn't escape or quote the semicolons used to separate multiple genres. Can this be fixed? Thanks... Link to comment Share on other sites More sharing options...
Luke Posted May 11, 2019 Share Posted May 11, 2019 Do you know what it should be changed to? Link to comment Share on other sites More sharing options...
chowbok Posted May 11, 2019 Author Share Posted May 11, 2019 It should enclose any field that has a semicolon in double quotes, e.g., ;x;x;x;The Maltese Falcon;4/25/19 11:20 PM;10/17/41 6:00 AM;1941;Mystery; Crime; Thriller;Not Rated;8.1;101mn;VC1;1920 * 1080;FLAC;x;x;x Should instead be ;x;x;x;The Maltese Falcon;4/25/19 11:20 PM;10/17/41 6:00 AM;1941;"Mystery; Crime; Thriller";Not Rated;8.1;101mn;VC1;1920 * 1080;FLAC;x;x;x Link to comment Share on other sites More sharing options...
Luke Posted May 11, 2019 Share Posted May 11, 2019 Ok, we'll take a look at it, thanks. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now