# I want to separate two words with Space after comma
**URL:** https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961
**Category:** Support
**Created:** [July 31, 2014, 5:31pm UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961 "2014-07-31T17:31:18Z")
**Posts on this page:** 17
**Page:** 1
### Author:  [@Giri\_Babu](https://community.mp3tag.de/u/Giri_Babu)
#### Post date: [July 31, 2014, 5:31pm UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/1 "2014-07-31T17:31:18Z")
Case: S.P. Balu,Chitra
In the above case I want to separate those two artists with Space like below
S.P. Balu, Chitra
is there any option to do that?
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [July 31, 2014, 6:03pm UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/2 "2014-07-31T18:03:54Z")
There is an action for that, a simple "Replace".
Search string would be: ,
(read "comma")
Replace string: ,
(read "comma blank")
If you accicdentally create double blanks then use another "Replace" action where you replace 2 blanks with 1.
If you have questions about these actions, see [/t/967/1](https://community.mp3tag.de/t/967/1) first.
---
### Author:  [@Giri\_Babu](https://community.mp3tag.de/u/Giri_Babu)
#### Post date: [July 31, 2014, 6:21pm UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/3 "2014-07-31T18:21:15Z")
> [@ohrenkino](#):
>
> If you accicdentally create double blanks
This answer enough for me. But I am expecting some more...
can we avoid double blanks problem?
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [August 1, 2014, 3:22am UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/4 "2014-08-01T03:22:14Z")
> [@Giribabu](#):
>
> This answer enough for me. But I am expecting some more...
> can we avoid double blanks problem?
You could devise a filter so that you see only the files that have no blank behind the comma:
%field% HAS "," AND NOT %field% HAS ", "
---
### Author:  [@Giri\_Babu](https://community.mp3tag.de/u/Giri_Babu)
#### Post date: [August 2, 2014, 12:42am UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/5 "2014-08-02T00:42:10Z")
Wow...
```
that's working fine. Thank you
```
and
can I avoid/add more than one word in filter?
Ex: %artist% HAS "Balu" AND NOT %artist% HAS "S.P. Balu"
in this case I able to avoid only "S.P. Balu". But I want to avoid "SP Balu" also.
ie. I want to avoid more than one word.
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [August 2, 2014, 6:51am UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/6 "2014-08-02T06:51:41Z")
If you really want to look for a specific string and that only, then use "IS" as filter instruction:
%artist% IS "Balu"
As "Balu" is part of the string that you are looking for and also part of the string that defines the exclusion criteria, it will not lead to a valid set. You would have to look for a different condition e.g.
%artist% HAS "Balu" AND "$len(%artist%)" GREATER 4
---
### Author:  [@Giri\_Babu](https://community.mp3tag.de/u/Giri_Babu)
#### Post date: [August 2, 2014, 3:40pm UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/7 "2014-08-02T15:40:41Z")
Ok... **ohrenkino** now I want to more clear about my concern.
Balu
SP Balu
S.P Balu
SP Balusubramanyam
S.P. Balasubramanyam
these all words refletcs only one artist "S.P. Balu"!
So I want to replace with "S.P. Balu" where ever comes above all words.
Now I am using "Replace" action, replacing one name once at a time.
Is there any easy way to solve this?
---
### Author:  [@DetlevD](https://community.mp3tag.de/u/DetlevD)
#### Post date: [August 3, 2014, 10:41am UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/8 "2014-08-03T10:41:48Z")
> [@Giribabu](#):
>
> ...
> Balu
> SP Balu
> S.P Balu
> SP Balusubramanyam
> S.P. Balasubramanyam
> these all words refletcs only one artist "S.P. Balu"!
> So I want to replace with "S.P. Balu" where ever comes above all words.
> ...
1.
Set Filter: ARTIST HAS " Balu" OR ARTIST HAS " Bala"
... or ...
Set Filter: ARTIST MATCHES "S.?P.? Bal.\*"
1.
Check displayed files.
Remove possible false positives from the file list.
1.
Use action (quick) "Format tag-field"
Field: ARTIST
Formatstring: 'S.P. Balu'
1.
Ready.
DD.20140803.1441.CEST
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [August 3, 2014, 11:17am UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/9 "2014-08-03T11:17:51Z")
> [@DetlevD](#):
>
> 1....
> 3.
> Use action (quick) "Format tag-field"
> Field: ARTIST
> Formatstring: 'S.P. Balu'
> ...
It might be even quicker to simply enter the correct Name in the tag panel and then save the modification ... I do not see the necessity for a one-off to create an action.
And in general: if I want to get all occurances of a name fragment then the whole hustle of different spellings is superfluous anyway as it won't do much harm to overwrite already correct files with correct data again...
Could it be that I do not understand the complexity of this problem as I do not see any?
---
### Author:  [@DetlevD](https://community.mp3tag.de/u/DetlevD)
#### Post date: [August 3, 2014, 11:29am UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/10 "2014-08-03T11:29:57Z")
> [@ohrenkino](#):
>
> It might be even quicker to simply enter the correct Name in the tag panel and then save the modification ...
Note: I have suggested action (quick) ...
... but using [Ctrl+Q] Tag-Panel ...
... and entering the new string into the artist edit box might be the easiest way.
DD.20140803.1529.CEST
---
### Author:  [@Giri\_Babu](https://community.mp3tag.de/u/Giri_Babu)
#### Post date: [August 5, 2014, 6:14pm UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/11 "2014-08-05T18:14:20Z")
Hi **DetlevD**
Your suggest filters
ARTIST HAS " Balu" OR ARTIST HAS " Bala"
... or ...
ARTIST MATCHES "S.?P.? Bal.\*"
are working very good.
But problem is in ARTIST field not only filled with single artist. Multiple artists are there.
When I am using your suggested 3rd step (even as per **ohrenkino** TAG PANEL method) it's replacing all artists with single artist 'S.P. Balu'.
Ex. SP Balasubranaiam, Chitra, S. Janaki
After the process: S.P. Balu
So this method not working properly.
................
I think if we can use the above filters in Actions (Quick) list like "Format value, Replace with regular expression...." or any other is workable! Is it possible?
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [August 6, 2014, 3:54am UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/12 "2014-08-06T03:54:58Z")
> [@Giribabu](#):
>
> ...
> But problem is in ARTIST field not only filled with single artist. Multiple artists are there.
> ...
Yes, and this is a completely different problem from what you told us in the former posts. Even in post #7, where you wanted to be clearer, you left out the bit that you want to keep the rest of the field.
You will have to cater for several source strings as an "SP Balusubramanyam" is something completely different from "S.P. Balasubramanyam". And even the "Balu" (1st string) vs. "Bala" (2nd string, see your post in #7) will make it more or less impossible to think of a pattern that will lead to a sensible result.
You could try a "Replace with Regular Expression" with a
Search string: (S.\* Bal._, )(._)
Replace with: S.P. Balu $2
But as I cannot tell if there are other artists that may match the criteria.
In the meantime you probably could have replaced the artists manually.
---
### Author:  [@DetlevD](https://community.mp3tag.de/u/DetlevD)
#### Post date: [August 6, 2014, 4:46am UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/13 "2014-08-06T04:46:41Z")
> [@Giribabu](#):
>
> ... But problem is in ARTIST field not only filled with single artist. Multiple artists are there. ... So this method not working properly. ...
A different problem needs a different strategy.
Use the strategy 'divide and conquer'.
[http://en.wikipedia.org/wiki/Divide\_and\_conquer](http://en.wikipedia.org/wiki/Divide_and_conquer)
[http://en.wikipedia.org/wiki/Divide\_and\_conquer\_algorithms](http://en.wikipedia.org/wiki/Divide_and_conquer_algorithms)
In relation to Mp3tag this could mean to apply the Filter.
This could mean to count the amount of commas in the tagfield ARTIST.
You should be imaginative.
DD.20140806.0846.CEST
---
### Author:  [@DetlevD](https://community.mp3tag.de/u/DetlevD)
#### Post date: [August 6, 2014, 5:31am UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/14 "2014-08-06T05:31:33Z")
> [@Giribabu](#):
>
> ... I think if we can use the above filters in Actions (Quick) list like "Format value, Replace with regular expression...." or any other is workable! Is it possible?
**$regexp(%ARTIST%,'^(.\*)(\bS\.?\s?P\.?\s?Bal.\*?\b)(.\*)$','$1S.P. Balu$3') "aaa, bbb, S.P. Balasubramanyam, ccc, ddd" -\> "aaa, bbb, S.P. Balu, ccc, ddd" "aaa, bbb, S. P. Balasubramanyam, ccc, ddd" -\> "aaa, bbb, S.P. Balu, ccc, ddd" "S.P. Balasubramanyam" -\> "S.P. Balu"**
DD.20140806.0932.CEST
---
### Author:  [@Giri\_Babu](https://community.mp3tag.de/u/Giri_Babu)
#### Post date: [August 6, 2014, 5:07pm UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/15 "2014-08-06T17:07:50Z")
Hi **ohrenkino** ,
the method you told...
_You could try a "Replace with Regular Expression" with a
Search string: (S.\* Bal., )(.)
Replace with: S.P. Balu $2_
not worked! When I am using this... nothing happening!!
Hi **DetlevD**
I really don't know how to use the code which one you showed in the lost post. Please clarify me how to use it. I am really very eager to understand this new method.
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [August 6, 2014, 6:26pm UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/16 "2014-08-06T18:26:38Z")
You can check your regular expression with the function convert\>tag-tag
Enter the field, then enter as format string:
$regexp(%artist%,'(S.\* Bal._, )(._)','S.P. Balu, $2')
This should lead to
S.P. Balu, S. Janaki
so ... that nothing happens indicates that you have not told us the whole truth about the contents about the fields.
---
### Author:  [@system](https://community.mp3tag.de/u/system)
#### Post date: [February 9, 2026, 12:25pm UTC](https://community.mp3tag.de/t/i-want-to-separate-two-words-with-space-after-comma/15961/17 "2026-02-09T12:25:10Z")