Print

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

[David Sydney]

Hi all,
Long time user, and I use F6 to move rename files whenever I import items to standardise where and how they are storefd on the server. Howver I am a novice on expression or anything involving fields etc.

I have a bunch of music videos of songs (say ~ 30) that I am trying to rename - not the file, but the meta data name that appears within MC. Some of them are "Song Name - Artist - Show" some of them are "Show - Artist - Song Name"  is there a smarter way to eg. delete fist 7 characters of the name, or take the left portion and move it to the end etc. F6 move/copy does not seem to be designed for this...?

Thanks

[lepa]

To mass change field value your source data value needs to have same naming pattern in order to be able to parse it correctly.

In your case if your filenames have pattern like "Song Name - Artist - Show" you can use F12 i.e. get properties from filename tool.
There you can then give simple parsing orders to separate fields e.g.

[Name] - [Artist] - [Album]

This example will put Show stuff to album field you can of course use any fields you like

If filenames doesn't have this then you need parse fields from field which have the data e.g Name field to get artist from above like pattern select songs with this pattern so that you are editing artist press F2 and in artist field type

Code: [Select]

=ListItem([Name],1,/ -/ ) try with few files first and do undo if you messed up.
Above expression will use " - " as list delimiter and output item from index 1 of the list which is artist in that pattern so to print first index (0) you would type =ListItem([Name],0,/ -/ )