|
Printable Version of Topic
-Brading Software Message Board +--Forum: Mp3/Tag Studio Suggestions +---Topic: TAB delimited fields started by megatrax Posted by: megatrax on April 03 2003,01:57 Comma-separated fields led to problems when there was a comma in the title or description. When parsing from a data file, can we have fields separated by <TAB>? Or, howabout a future version that will parse directly from an Excel file? Thank you. Posted by: Magnus Brading on April 03 2003,12:08 Right now you cannot use TABs as field delimiters (simply because you cannot enter TABs into Windows editboxes), but you can use any character that can be entered into the template text box. If you have a tab-delimited file, simply do a search/replace of all the TABs to something else (with some text editor) and you will then be able to import it without any problems. Also, you can easily export any Excel sheet to a CSV file (fields separated woth e.g. ";") from inside Excel, and then import this file into Mp3/TS, so implementing direct support for parsing Excel files in Mp3/TS would be a little superfluous I think. Posted by: bradp on April 29 2003,07:09 A note to performing a find and replace in Win XP notepad. I noticed when working from excel and exporting to a text file, the only way to search and replace the tabs was to literaly highlight the "tab space" in the text file and use copy and paste to add it the the "Find" field in the Find and Replace Option on the Edit Menu. Then replaced the tabs with a ; character before importing into Tag Studio. Worked great on 7000+ files. end |