IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> CSV Export with seperate cells
hillcreative
post Jun 8 2017, 20:10
Post #1


Member


Group: Full Members
Posts: 12
Joined: 20-February 17
Member No.: 23093
Mp3tag Version: 2.81



Trying to use the default CSV export but output creates a single cell for header and data output. I'd like each data item to reside in a single CSV cell instead of ";" as a separator.
Go to the top of the page
 
+Quote Post
ohrenkino
post Jun 8 2017, 20:25
Post #2


Member


Group: Full Members
Posts: 9125
Joined: 9-December 09
From: Norddeutschland / Northern Germany
Member No.: 11458
Mp3tag Version: 2.84d



ZITAT(hillcreative @ Jun 8 2017, 21:10) *
Trying to use the default CSV export but output creates a single cell for header and data output. I'd like each data item to reside in a single CSV cell instead of ";" as a separator.

What do you mean by "single CSV cell"?
The ; is the "C" in CSV ("comma") and if you import a CSV file e.g. into Excel, you get every piece of data that sits between a ; in a single cell.

So what should the result look like?


--------------------
42 - wie war die Frage / what was the question / quelle était la question
Go to the top of the page
 
+Quote Post
hillcreative
post Jun 9 2017, 00:27
Post #3


Member


Group: Full Members
Posts: 12
Joined: 20-February 17
Member No.: 23093
Mp3tag Version: 2.81



QUOTE (ohrenkino @ Jun 8 2017, 14:25) *
What do you mean by "single CSV cell"?
The ; is the "C" in CSV ("comma") and if you import a CSV file e.g. into Excel, you get every piece of data that sits between a ; in a single cell.

So what should the result look like?
Each header such as ARTIST TITLE SONG should end up in a separate cell instead of a single cell with each field separated by a ; When I look at the export result the first cell contains all the data!
Go to the top of the page
 
+Quote Post
hillcreative
post Jun 9 2017, 02:34
Post #4


Member


Group: Full Members
Posts: 12
Joined: 20-February 17
Member No.: 23093
Mp3tag Version: 2.81



QUOTE (hillcreative @ Jun 8 2017, 18:27) *
Each header such as ARTIST TITLE SONG should end up in a separate cell instead of a single cell with each field separated by a ; When I look at the export result the first cell contains all the data!
Answer my own question: use a comma "," not a ";" for separate cell entries. Also don't forget to quote around the metatags so a comma in the tag triggers another cell or field.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 17th October 2017 - 23:21