Hello,
First thanks for a great product. I wish to replace the semi colon with another character. Say the '+' symbol. Some of my album titles seem to have the ; character within them and this leads to a mixed up output file when I import into Excel. I have deduced that I might be able to edit the script file. But would welcome some guidance. I'm an electronics engineer, less a programmer today. Thanks in advance for your help.
Excel allows to import data sets that include a semicolon if it has been marked as a string. A string is encapsulated in inverted commas: "
So if you modify your export script in such a way that you enclose the fields that might have semicolons in them in " then you are clean.
E.g., the (almost) standard csv-export-script looks like this:
$filename(csv,utf-16)Titel;Interpret;Album;Track;Jahr;Länge;Größe;Geändert;Pfad;Dateiname;
$loop(%_filename_ext%)%title%;%artist%;%album%;%track%;%year%;%_length_seconds%;%_file_size%;%_file
_mod_date%;%_folderpath%;%_filename_ext%;
$loopend()
If you think that you will have trouble in title, then modify the text like this:
$filename(csv,utf-16)Titel;Interpret;Album;Track;Jahr;Länge;Größe;Geändert;Pfad;Dateiname;
$loop(%_filename_ext%)"%title%";%artist%;%album%;%track%;%year%;%_length_seconds%;%_file_size%;%_file
_mod_date%;%_folderpath%;%_filename_ext%;
$loopend()
Please note the opening " and closing " around %title%.
Modify all the fields you need (e.g. ARTIST, ALBUM)
I highly recommend the "global export" addon Mp3tagCompleteTags.
Many great additional benefits, but in your case I'll just mention it uses a special Unicode "x" character as a delimiter.
Read there about the CSV file format ...
http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm
http://en.wikipedia.org/wiki/Comma-separated_values
http://csved.sjfrancke.nl/
DD.20120825.1045.CEST
So if you modify your export script in such a way that you enclose the fields that might have semicolons in them in " then you are clean.
E.g., the (almost) standard csv-export-script looks like this:
$filename(csv,utf-16)Titel;Interpret;Album;Track;Jahr;Länge;Größe;Geändert;Pfad;Dateiname;
$loop(%_filename_ext%)%title%;%artist%;%album%;%track%;%year%;%_length_seconds%;%_file_size%;%_file
_mod_date%;%_folderpath%;%_filename_ext%;
$loopend()
If you think that you will have trouble in title, then modify the text like this:
$filename(csv,utf-16)Titel;Interpret;Album;Track;Jahr;Länge;Größe;Geändert;Pfad;Dateiname;
$loop(%_filename_ext%)"%title%";%artist%;%album%;%track%;%year%;%_length_seconds%;%_file_size%;%_file
_mod_date%;%_folderpath%;%_filename_ext%;
$loopend()
Please note the opening " and closing " around %title%.
Modify all the fields you need (e.g. ARTIST, ALBUM)
Hello,
I thought I'd try this first. I've edited the csv.mte file in the \export folder. First trying to eliminate "%title%" , then other fields. But nothing changes, I appear to get all of the fields as below? I must be doing something wrong here. Can you explain this behaviour please? Thanks for your help.
Alan
I am not quite sure what you did.
To edit an export definition open
File>Export
and select the desired export. Press the Edit button.
Perform the changes and save the file.
Please not that the file has to have the extension .mte
Also please note: the first line contains the headlines but not field definitions.
Only variables enclosed in % (like %title%) get filled with the actual contents from the tags.
For further help it will be easier if you enclosed your concrete export script.
I edited the file manually using a text editor. I didn't use the built in edit function. Maybe that's why it didn't work for me. Thanks again for your help. I will retry.
Alan