» Welcome Guest
[ Log In :: Register ]

 

[ Track this topic :: Email this topic :: Print this topic ]
Topic: TAB delimited fields, Parsing from Excel files?< Next Oldest | Next Newest >
megatrax
Board Newbie



Group: Members
Posts: 4
Joined: April 2003
Posted: 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.
Back to top
Profile PM 
Magnus Brading
Almighty Author



Group: Super Administrators
Posts: 2751
Joined: Aug. 2002
Posted: 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.

--------------
Software author and website owner
Back to top
Profile PM WEB 
bradp
Board Newbie



Group: Members
Posts: 6
Joined: April 2003
Posted: 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.
Back to top
Profile PM 
2 replies since April 03 2003,01:57 < Next Oldest | Next Newest >

[ Track this topic :: Email this topic :: Print this topic ]