# How can I split separated with semicolons data from csv flie using regexp?

**URL:** <https://community.mp3tag.de/t/how-can-i-split-separated-with-semicolons-data-from-csv-flie-using-regexp/56086>\
**Category:** Support\
**Created:** [January 27, 2022, 1:31pm UTC](https://community.mp3tag.de/t/how-can-i-split-separated-with-semicolons-data-from-csv-flie-using-regexp/56086 "2022-01-27T13:31:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Simos\_Sigma](https://community.mp3tag.de/user_avatar/community.mp3tag.de/simos_sigma/32/9966_2.png) [@Simos\_Sigma](https://community.mp3tag.de/u/Simos_Sigma)\
**Post date:** [January 27, 2022, 1:31pm UTC](https://community.mp3tag.de/t/how-can-i-split-separated-with-semicolons-data-from-csv-flie-using-regexp/56086/1 "2022-01-27T13:31:36Z")

</div>

Greetings to community!!! 🙂

From an other program I use I managed to export, for example, these data: `Z:\MUSIC\MP3\Rest of the World\9 PM (Till I Come) (Radio Edit) - ATB.mp3;320;20045;0,37;0;0;` to a `.csv` file. Then I stored them into `comment` tag as they look, using the `Text file - Tag` command from `mp3tag`.

Now, what I want to do, is to split this thing to parts and send every value to corresponding tag. I know I have to make an `action` with a `regexp` in `format string` field, but I don't know how to use `regexp`!!!

Anyone can help me on this?

Let's say I want to take the part with the number `320` and put it on `REAL BITRATE` tag.

![Untitled-1](https://community.mp3tag.de/uploads/default/original/2X/8/85253f0d254d1683211c4caf6e1e90fe354b365c.jpeg)

Thank you for your time!!! 🙂

---

<div class="post-metadata">

**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:** [January 27, 2022, 1:38pm UTC](https://community.mp3tag.de/t/how-can-i-split-separated-with-semicolons-data-from-csv-flie-using-regexp/56086/2 "2022-01-27T13:38:14Z")

</div>

You could have used the CSV file straightaway to assign the data to the respective fields with a mask like  
%dummy%;%real bitrate%;%dummy%;%dummy%,%dummy%;%dummy%;%dummy%;  
Does it have to be a regular expression?  
Because I would use an action of the type "Guess value"  
Source: %comment%  
Target string: `%dummy%;%real bitrate%;%dummy%;%dummy%,%dummy%;%dummy%;%dummy%;`  
(you have to check whether I got the right piece of information. You have to delete or add another %dummy%😉

---

<div class="post-metadata">

**Author:** ![Simos\_Sigma](https://community.mp3tag.de/user_avatar/community.mp3tag.de/simos_sigma/32/9966_2.png) [@Simos\_Sigma](https://community.mp3tag.de/u/Simos_Sigma)\
**Post date:** [January 27, 2022, 2:06pm UTC](https://community.mp3tag.de/t/how-can-i-split-separated-with-semicolons-data-from-csv-flie-using-regexp/56086/3 "2022-01-27T14:06:04Z")

</div>

Oh my god!!! You know what? I was initially trying to do this using the CSV file straightaway, exactly as you said, but for some reason I was typing commas between dummies and tags instead of semicolons!!! 😆

Your "Guess value" example is very useful too!!!

Thank you very much and sorry I spent your time on something like this!!! 🙂

---

<div class="post-metadata">

**Author:** ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)\
**Post date:** [February 26, 2022, 2:06pm UTC](https://community.mp3tag.de/t/how-can-i-split-separated-with-semicolons-data-from-csv-flie-using-regexp/56086/4 "2022-02-26T14:06:56Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.