# Mp3tag Columns Extraction **URL:** \ **Category:** Support\ **Created:** [March 21, 2020, 9:03pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217 "2020-03-21T21:03:06Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![dp19](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/a8b319/32.png) [@dp19](https://community.mp3tag.de/u/dp19)\ **Post date:** [March 21, 2020, 9:03pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/1 "2020-03-21T21:03:06Z")
Hi, i like to extract some columns from mp3tag to an open office doc but for some reason i cannot do this. i'm no programmer so any help would be wonderful. these are the columns i like to extract artist / country. Than You ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [March 21, 2020, 9:07pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/2 "2020-03-21T21:07:39Z")
Here is a thread that deals with the problem to export the field ARTIST > [@How can I export only one tag "Artist" in a txt file?](https://community.mp3tag.de/t/how-can-i-export-only-one-tag-artist-in-a-txt-file/48214): > > hello friends, have a nice day I need to export a tag, just the "artist" tag (and nothing else), into a text file (.txt). What I do is go to menu "file", then "export", "txt\_taglist" option, but that option gives me a lot of information (filename, artist, title), and I just need to export "artist" tag for a list of files mp3. It is a problem this time having a lot of information (filename, track, title) in the resulting txt file because then I have to erase line by line the information … You only have to append the code with the variable name for country (which is no standard tag field). ---
**Author:** ![dp19](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/a8b319/32.png) [@dp19](https://community.mp3tag.de/u/dp19)\ **Post date:** [March 22, 2020, 12:36pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/3 "2020-03-22T12:36:16Z")
Thanks for your reply. i read that thread but i do not understand programming. i can't highlight the fields and copy/paste. is there anoth way do to what i like? Thanks ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [March 22, 2020, 12:44pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/4 "2020-03-22T12:44:17Z")
> [@dp19](#): > > is there anoth way do to what i like? I am afraid not. The only way to export tag data is either via the clipboard from one taggable file to the other or via text files. And where did that thread say anything about highlighting? Which field contains the country information? What format should the resulting file be so that it can be read by the target application? ---
**Author:** ![dp19](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/a8b319/32.png) [@dp19](https://community.mp3tag.de/u/dp19)\ **Post date:** [March 22, 2020, 5:51pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/5 "2020-03-22T17:51:55Z")
Thanks for the input. like a said i'm no programmer so for me this isn't an option. what i meant by highlight was i thought that mp3tag use to be able highlight a column and then export. now i see that can't be done. Again Thanks for you time. ---
**Author:** ![dp19](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/a8b319/32.png) [@dp19](https://community.mp3tag.de/u/dp19)\ **Post date:** [March 24, 2020, 1:04pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/6 "2020-03-24T13:04:28Z")
hi, can anyone give the code to create artist / POB (custom column) so i can try o create a csv to create a open doc spreadsheet for these two columns please. Thank You ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [March 24, 2020, 1:09pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/7 "2020-03-24T13:09:03Z")
Create a new export and enter the following: ` $filename(csv,utf-16)$loop(%artist%)"%artist%";"%pob%`" `$loopend()` ---
**Author:** ![dp19](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/a8b319/32.png) [@dp19](https://community.mp3tag.de/u/dp19)\ **Post date:** [March 24, 2020, 1:19pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/8 "2020-03-24T13:19:52Z")
THANK YOU!! what does $filename(csv,utf-16) stand for and do? ---
**Author:** ![dp19](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/a8b319/32.png) [@dp19](https://community.mp3tag.de/u/dp19)\ **Post date:** [March 24, 2020, 1:44pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/9 "2020-03-24T13:44:56Z")
ok i created a test csv but i don't understand or know how to get it to export artist / pob only. ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [March 24, 2020, 2:47pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/10 "2020-03-24T14:47:53Z")
> [@dp19](#): > > i created a test csv I've shown you mine, so show me yours: What does your code look like for the export? What is the real name of the user defined field? Where did you get stuck when following the description of how to create a new export script that I linked? > [@How can I export only one tag "Artist" in a txt file?](https://community.mp3tag.de/t/how-can-i-export-only-one-tag-artist-in-a-txt-file/48214): > > hello friends, have a nice day I need to export a tag, just the "artist" tag (and nothing else), into a text file (.txt). What I do is go to menu "file", then "export", "txt\_taglist" option, but that option gives me a lot of information (filename, artist, title), and I just need to export "artist" tag for a list of files mp3. It is a problem this time having a lot of information (filename, track, title) in the resulting txt file because then I have to erase line by line the information … ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [March 24, 2020, 3:09pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/11 "2020-03-24T15:09:17Z")
> [@dp19](#): > > what does $filename(csv,utf-16) stand for and do? It sets the character encoding to utf-16 and the file extension to csv so that the default application for comma separated value files opens the file when double-clicking or viewing the result. ---
**Author:** ![dp19](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/a8b319/32.png) [@dp19](https://community.mp3tag.de/u/dp19)\ **Post date:** [March 24, 2020, 3:47pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/12 "2020-03-24T15:47:19Z")
i finally got it correct but now on the spreadsheet they show up in one cell only. is there a way mp3tag can put artist in one column and pob in another without doing a c/p within the spreadsheet or creating individual csv. i'm trying to save time over 14,000 files is alot to do. Thank You ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [March 24, 2020, 4:34pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/13 "2020-03-24T16:34:20Z")
> [@ohrenkino](#): > > `$filename(csv,utf-16)$loop(%artist%)"%artist%";"%pob%` " You could try if the following works better (replace the old code line with one of the following suggestions): `$filename(csv,utf-16)$loop(%artist%)%artist%$char(9)%pob%` (which uses the tab character as field separator) or `$filename(csv,utf-16)$loop(%artist%)%artist%,%pob%` (which uses the comma as field separator) ---
**Author:** ![dp19](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/a8b319/32.png) [@dp19](https://community.mp3tag.de/u/dp19)\ **Post date:** [May 16, 2020, 5:33pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/14 "2020-05-16T17:33:24Z")
Thanks another question i like to replace the - to / in my filename how can this be done please. i would like to do this for multi tracks at once. Thank You ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [May 16, 2020, 5:41pm UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/15 "2020-05-16T17:41:51Z")
> [@dp19](#): > > replace the - to / in my filename I think that this leads to an invalid filename as the / is not permitted. (and which filename are we talking about?) ---
**Author:** ![dp19](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/a8b319/32.png) [@dp19](https://community.mp3tag.de/u/dp19)\ **Post date:** [May 17, 2020, 12:18am UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/16 "2020-05-17T00:18:12Z")
Thanks i got it figure out. ---
**Author:** ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)\ **Post date:** [May 29, 2023, 7:36am UTC](https://community.mp3tag.de/t/mp3tag-columns-extraction/48217/17 "2023-05-29T07:36:05Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.