More > JRiver Media Center 21 for Windows

Tag manipulation with expression language

<< < (3/3)

ferday:
Where did you paste it?  Into a field or a column?

I still haven't tested my second one but my first one tested fine...its probably the = try


--- Code: ---=if(isequal(left([Album],2),d_,1),replace([album],D_,DS-),[Album])
--- End code ---

jacobacci:
@ferday,
pasting the expression with the = into the "alt enter" album field did the trick.
The expression I ended up using was
=if(isequal(left([Album],2),D_,1),replace([album],D_,DSD_),[Album])
This did exactly what I had intended.
Thanks a lot to everyone for their help. You guys shortened my learning curve by days.

blgentry:
Happy to hear it worked out for you.  ...and +1 to our man Ferday for the expression that both worked AND was easy enough to understand for a new user!

I've heard Perl described as line noise before but not regex.  Not that I *deny* it.  :)  I just like it because once you know it, it works for so many different things.  Regex literally does the job of something like 4 or 5 different functions in the Expression Language.  Perhaps more...

Brian.

dtc:
I believe the replace function replaces all instances of D_ with DSD_. Since there is an off chance that D_ may occur in the rest of the string, another option is to add DS to the beginning of the string, by adding DS to [Album]. In MC there is no concatenate function, so you just add the letters.

=if(isequal(left([Album],2),D_,1),DS[Album],[Album])

In this case, replace would probably work fine. I just wanted to add another option.

jacobacci:
Thanks a lot. I'll be an expert before long
 :)

Navigation

[0] Message Index

[*] Previous page