# Format Value query
**URL:** https://community.mp3tag.de/t/format-value-query/12703
**Category:** Support
**Created:** [November 17, 2011, 1:11am UTC](https://community.mp3tag.de/t/format-value-query/12703 "2011-11-17T01:11:40Z")
**Posts on this page:** 3
**Page:** 2
### Author:  [@DetlevD](https://community.mp3tag.de/u/DetlevD)
#### Post date: [November 29, 2011, 12:49pm UTC](https://community.mp3tag.de/t/format-value-query/12703/21 "2011-11-29T12:49:15Z")
> [@stevehero](#):
>
> ... You will notice how the file is named affects the way it appears in the program.
Hi stevehero ... please consider.
1.
When working on all tag-fields at once, by using the pseudo tag-field \_TAG, that bears risk.
For example, the content of the tag-field like "COMMENT ITUNNORM" will loose it's leading space character.
1.
Note, the regular expression character class "\s" includes all "whitespace" characters.
For example, try yourself ...
Begin Action Group **Test\_2011#20111129.Test.WhitespaceCharacters**
Action #1
_Actiontype 5:_ **Format value**
_Field \_\_\_\_\_\_:_ **TEST\_WHITESPACE**
_Formatstring:_ **$regexp('1'$char(9)'2'$char(10)'3'$char(11)'4'$char(12)'5'$char(13)'6'$char(32)'7','\s',)**
End Action Group **Test\_2011#20111129.Test.WhitespaceCharacters** (1 Action)
The result of this action is the text string: "1234567"
1.
**$regexp(' TEST ','^ +| +$',) is the same as $trim(' TEST ') ... and even harder ... $regexp($char(9)$char(10)$char(11)$char(12)$char(13)$char(32)'TEST'$char(9)$char(10)$char(11)$char(12)$char(13)$char(32),'^\s+|\s+$',)**
The result of this expression is the text string: "TEST"
DD.20111129.1455.CET
---
### Author:  [@stevehero](https://community.mp3tag.de/u/stevehero)
#### Post date: [December 1, 2011, 11:04pm UTC](https://community.mp3tag.de/t/format-value-query/12703/22 "2011-12-01T23:04:35Z")
> [@DetlevD](#):
>
> Hi stevehero ... please consider.
>
> 1.
>
> When working on all tag-fields at once, by using the pseudo tag-field \_TAG, that bears risk.
>
> For example, the content of the tag-field like "COMMENT ITUNNORM" will loose it's leading space character.
Hi DetlevD,
Thanks for these axamples, but I haven't been at a computer these last few days, only on my phone atm.
But could you add an action to replace the COMMENT ITUNNORM below your delete unwanted 'whitespace' in an action group or are there more TAGS which behave like this. Perhaps the LYRICS tag is one more?
e.g. For the COMMENT ITUNNORM tag
Regexp: (\w)
replace with: whitespacecharacter$1
Could you also please give a realworld example of how them actions work or are they already ones?
As I've said on my fone so unable to test them, Thanks.
---
### Author:  [@system](https://community.mp3tag.de/u/system)
#### Post date: [February 9, 2026, 12:23pm UTC](https://community.mp3tag.de/t/format-value-query/12703/23 "2026-02-09T12:23:26Z")
[Previous page](https://community.mp3tag.de/t/format-value-query/12703.md?page=1)