EB_Joe
November 29, 2012, 11:05pm
1
$left(%title%,$sub($len(%title%),6))'xxxx'$right(%title%,6)
The above will insert xxxx at 6 characters from the RIGHT side of the field within %%, whatever field that is. For the life of me, whatever I try (for 6 hours now), I cannot figure out how to change it so it will insert xxxx at 6 characters from the LEFT side of the field. I am assuming it is not possible. Any help?
Try this solution, there are different ways to do this but give this a go.
Begin Action Group _Script Test#TEST
Action #1
Actiontype 5: Format value
Field ______: TITLE
Formatstring: $regexp(%title%,'^(.{6})(.*)','$1xxxx$2')
End Action Group _Script Test#TEST (1 Action)
Results:
"[Untitled Track] 01" ->
" [Untitxxxxled Track] 01"
"1999" ->
" 1999"
"[Untitled] 04" ->
" [Untitxxxxled] 04"
"TEST" ->
" TEST"
"Dark Flower EP Epic (OM)" ->
" Dark Fxxxxlower EP Epic (OM)"
Screenshot of regexp:
Change:
'xxxx' in this '$1xxxx$2' to your liking
DetlevD
November 30, 2012, 2:47am
3
... The above will insert xxxx at 6 characters from the RIGHT side of the field within %%, whatever field that is. For the life of me, whatever I try (for 6 hours now), I cannot figure out how to change it so it will insert xxxx at 6 characters from the LEFT side of the field. I am assuming it is not possible. Any help?
See post there ...
Aktion 'Wert einschieben an Position'
DD.20121130.0442.CET