Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[KingSparta]

I Am Trying To Work With Audio Books

Is There A Way That You Can Use A Condition In A Calculated Field?

So If You Had "Name" As 010-175 That The Calculated Field Would PrePend A "Part" In The Calculated Field?

Also If There Was No "Parts" In The "Name" Field MC Would Append "Parts" To The End Of The Field.

Also Convert "-" To " Of "

I Would Also Want MC To Use The "Artist" Field To See If The Artist Name Is In The "Name" Field, And If It Is Have The Calculated Field Change It With Null String Or Something Else.

I Would Also Want MC To Use The "Album" Field To See If The Album Name Is In The "Name" Field, And If It Is Have The Calculated Field Change It With Null String Or Something Else.

Original Field Data: "010-175"
New Field Data: "Part 010 Of 175 Parts"

[marko]

It's not clear to me exactly what you require...
Do you wish to create a completely new field, or are you looking to update the [name] field itself?
As everything you ask is keying off the [name] field, any rules or expressions would need to deal with all the variations in the [name] field for the audiobook files.

We cannot use expressions to replace "-" with " Of ". We can check for the existance of "-" within the [name] field, or in a specific place in the [name] string and react to the results. The same applies if you mean you would like the [artist] or [album] reference removed from the [name] field when you say "And If It Is Have The Calculated Field Change It With Null String Or Something Else.". It is possible to go the other way and say that if the [artist] is in the name field, then don't show [artist].

Original Field Data: "010-175"
New Field Data: "Part 010 Of 175 Parts"

This gives returns what you need from any [name] field filled like so: [xxx-xxx]
if(isequal(mid([name],3),-),Part mid([name],0,3) Of mid([name],4,3) Parts,)

You can place that in the template field of a new calculated data field. If you want to see it action first, pick an empty field in the tag window, [comment] perhaps, and enter it like so:
=if(isequal(mid([name],3),-),Part mid([name],0,3) Of mid([name],4,3) Parts,)
when you press enter, the comment field would look like so: "Part 010 Of 175 Parts"

[KingSparta]

I have been editing Over 40,000 Audio Book files

Normaly They Have Data In The Name Like 010-175

I Wish To Create A Calculated Field That Will Add Part And Parts Along With Changing "-" to " Of "

This Will Allow Me To Use This Calculated Field When Using Rename From Propeties To Crate A File Name In The Way I Wish.

If We Had A Append And PrePend Option In Tools This Would Also help Me.

I Am Just Trying To Figure Out If There Is A Work Around, Due To The Lack Of The Append And PrePend Option.

[KingSparta]

your code sort of works, but sometimes the "-" is not in pos 4 and sometimes it is already replaced with "of"

Like

Witches' Brew - 224 of 225

Or

Witches' Brew - 224 - 225

Or

224 - 225

Or

224 Of 225

Or

224-225

Etc....

[leezer3]

As someone else with a huge number of these type of files (Library is currently at 150k files & growing, mostly either audiobooks or OTR), I'd also be interested in something that can do this.
Most expressions go over my head, but just as a thought- Wouldn't it be easier to calculate it from the track numbers, instead of trying to use what's already in the filename? This should produce the same result for any different file. So, it would look something like this-

Part {Track Number} of {Final Track Number}

All this is really required for is neatness though- I listen to these on the Ipod, & I don't notice it for more than the two seconds it takes me to press play and drop it in my pocket

Another tool that I think would be welcomed by audiobook users would be the ability to merge MP3 files. As far as I'm aware this currently has to be handled by an external application or ignored; It would be amazing if I could simply set the track numbers & tell MC to merge the files. Wouldn't be too difficult to implement either really

-Leezer-

[KingSparta]

Another tool that I think would be welcomed by audio book users would be the ability to merge MP3 files.

Yes, I Had To Buy "MP3 Splitter & Joiner Pro" To Do This.

MP3 Splitter & Joiner Pro only re-encodes the files if the encoding on all parts are different, so it was faster than the others I tested.